皮皮学，免费搜题
登录
搜题
【单选题】
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 database at the corporate headquarters. A Data Transformation Services (DTS) package transforms the sales records, as they are loaded. The package writes the transformed sales records to the Sales table, which has a column for integer primary key values. The IDENTITY property automatically assigns a key value to each transformed sales record. After loading this month's sales data, you discover that a portion of the data contains errors. You stop loading data, identify the problem records, and delete those records from the database. You want to reuse the key values that were assigned to the records that you deleted. You want to assign the deleted key values to the next sales records you load. You also want to disrupt users' work as little as possible. What should you do?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.
拍照语音搜题，微信中搜索"皮皮学"使用
参考答案：
参考解析：
知识点：
皮皮学刷刷变学霸
举一反三
【单选题】在同温同压下,相同体积的烧瓶分别充满氨气和 HCl 气体,做喷泉实验后,水都充满烧瓶,烧瓶中所得溶液的物质的量浓度之比是(提示:从浓度基本计算公式考虑溶液体积和溶质的n关系) ( )
A.
1∶0.45
B.
1∶1
C.
1∶0.29
D.
4.5∶2.9
【多选题】短周期元素X和Y，X原子的电子层数为n，最外层电子数为（2n+1），Y原子最外层电子数是次外层电子数的3倍．下列说法一定正确的是（ ）
A.
X和Y都是非金属元素，其中X的最高化合价为+5价
B.
元素X可形成化学式为KXO 3 的盐
C.
X与Y所能形成的化合物都是酸性氧化物
D.
X的氢化物极易溶于水，可以用来做喷泉实验
【简答题】水电厂按运行方式分为（）。
相关题目：