You administer a Microsoft SQL Server 2012 database. You use an OrderDetail table that has the following
definition:
You need to create a non-clustered index on the SalesOrderID column in the OrderDetail table to include only
rows that contain a value in the SpecialOfferID column. Which four Transact-SQL statements should you use?
(To answer, move the appropriate statements from the list of statements to the answer area and arrangethem
in the correct order.)
Answer:
Explanation:
