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.