知识检查

1.

你希望将 Store.Product 表中的数据插入名为 Sales.Offer 的现有表中。你应该用哪个语句？

INSERT INTO Sales.Offer SELECT ProductID, Name, Price*0.9 FROM Store.Product;

SELECT ProductID, Name, Price*0.9 FROM Store.Product INTO Sales.Offer;

INSERT INTO Sales.Offer (ProductID, Name, Price*0.9) VALUES (Store.Product);

2.

你需要确定 Sales.Invoice 表中最近插入的 IDENTITY 列。你应该用哪个语句？

SELECT SCOPE_IDENTITY() FROM Sales.Invoice;

SELECT IDENT_CURRENT('Sales.Invoice');

SELECT NEXT VALUE FOR Sales.Invoice;

3.

必须将类别 2 中所有产品的价格提高 10%。你应该用哪个语句？

UPDATE Store.Product SET Price = Price * 1.1, Category = 2;

UPDATE Store.Product SET Price = Price * 1.1 WHERE Category = 2;

SELECT Price * 1.1 INTO Store.Product FROM Store.Product WHERE Category = 2;

反馈