Explain how to work around the SQL Server IDENTITY constraint when non-sequential data must be entered
What will be an ideal response?
The Transact-SQL IDENTITY_INSERT property allows users to control whether or not the IDENTITY constraint is in effect. To insert non-sequential data, we (1 ) use the command SET IDENTITY_INSERT {tableName} OFF to disable the IDENTITY constraint, (2 ) insert the non-sequential data, and (3 ) use the command SET IDENTITY_INSERT {TableName} ON to enable the IDENTITY constraint again.
You might also like to view...
What are the secondary sources of data and how do these sources differ from primary sources? Give examples of sources from which secondary data can be obtained
What will be an ideal response?
Answer the following statements true (T) or false (F)
The SEC has allowed accounting policy-making power to remain in the private sector.
Your goal should be to come across as a polished actor during your presentation
a. true b. false
At common law, the risk of loss or damage to goods identified under a contract of sale falls upon:
A) the buyer. B) the seller. C) the party who had title or ownership of the goods at the time of the loss or damage. D) the designated party as determined by the court.