【简答题】ACME Atlantic is a well-known and respected trading company. We handle import directly from manufacturers in 35 different countries, often to our own specifications and currently export to 46 differen...
【单选题】You are the database administrator for a retail company. The company owns 270 stores. Every month, each store submits approximately 2,000 sales records, which are loaded into a SQL Server 2000 databas...
A.
Export all records from the Sales table to a temporary table. Truncate the Sales table, and then reload the records from the temporary table.
B.
Export all records from the Sales table to a text file. Drop the Sales table, and then reload the records from the text file.
C.
Use the DBCC CHECKIDENT statement to reseed the Sales table's IDENTITY property.
D.
Set the Sales table's IDENTITY_INSERT property to ON. Add new sales records that have the desired key values.
【简答题】ACME Atlantic is a well-known and respected trading company. We handle with imports directly from manufacturers in 35 different 【M1】______ countries, often to our own specifications, and currently imp...