You administer a database that includes a table named Customers that contains more than 750 rows. You create a new column named PartitionNumber of the int type in the table. You need to assign a PartitionNumber for each record in the Customers table. You also need to ensure that the PartitionNumber satisfies the following conditions:

Always starts with 1.

Starts again from 1 after it reaches 100.

Which Transact-SQL statement should you use?

Question

You administer a database that includes a table named Customers that contains more than 750 rows. You create a new column named PartitionNumber of the int type in the table. You need to assign a PartitionNumber for each record in the Customers table. You also need to ensure that the PartitionNumber satisfies the following conditions:

Always starts with 1.
Starts again from 1 after it reaches 100.

Which Transact-SQL statement should you use?

Accepted Answer

B. CREATE SEQUENCE CustomerSequence AS int

Answer

A. CREATE SEQUENCE CustomerSequence AS int

Answer

C. CREATE SEQUENCE CustomerSequence AS int

Answer

D. CREATE SEQUENCE CustomerSequence AS int

You administer a database that includes a table named Customers that contains more than 750 rows. You create a new column named PartitionNumber of the int type in the table. You need to assign a…

Question

Options

How the community answered

Community Discussion