皮皮学，免费搜题
登录
搜题
【单选题】
You are a database developer for Wide World Importers. You are creating a database that will store order information. Orders will be entered in aclient/server application. Each time a new order is entered, a unique ordernumber must be assigned. Order numbers must be assigned in ascending order. Anaverage of 10,000 orders will be entered each day. You create a new table namedOrders and add an OrderNumber column to this table. What should you do next?A.
Set the data type of the column to UniqueIdentifier.
B.
Set the data type of the column to int, and set the IDENTITYproperty for the column.
C.
Set the data type of the column to int. Create a user-defined function that selects the maximum order number in the table.
D.
Set the data type of the column to int. Create a NextKey table,and add a NextOrder column to the table. Set the data type of the NextOrdercolumn to int. Create a stored procedure to retrieve and update the value heldin the NextKey.
拍照语音搜题，微信中搜索"皮皮学"使用
参考答案：
参考解析：
知识点：
皮皮学刷刷变学霸
举一反三
相关题目：