You are a database developer for wide world importers. You are creating a database that will store order information. Orders will be entered in a client/server application. Each time a new order is entered, a unique order number must be assigned. Order numbers must be assigned in ascending order. An average of 10, 000 orders will be entered each day. You create a new table named Orders and add an OrderNumber column to this table. What should you do next

243.

You are a database developer for wide world importers.
You are creating a database that will store order information. Orders will be entered in a client/server application.
Each time a new order is entered, a unique order number must be assigned.
Order numbers must be assigned in ascending order. An average of 10, 000 orders will be entered each day.
You create a new table named Orders and add an OrderNumber column to this table.

What should you do next

Set the data type of the column to uniqueidentifier.

Set the data type of the column to int.
Create a user-defined function that selects the maximum order number in the table.

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 NextOrder column to int.
Create a stored procedure to retrieve and update the value held in the NextKey.

Set the data type of the column to int, and set the IDENTITY property for the column.

View Description

No description found.