Explain the SQL Server IDENTITY constraint
What will be an ideal response?
The IDENTITY constraint is used to define surrogate keys in SQL Server. The syntax IDENTITY (m,n) is used to specify a surrogate key with an Identity Seed (starting value) of m and an Identity Increment (increment value) of n. Thus the statement IDENTITY (100,2 ) will start a sequence at 100 and increase it by 2 each time. If the IDENTITY constraint is applied to an existing column in an existing table that has existing data, the Identity Seed will be automatically set to the greater of (1 ) the Identity Seed or (2 ) the largest data value already in the column. This insures that no existing data values will be duplicated.
You might also like to view...
Negotiator passivity, loss of initiative, and dependence on the third party are common results of recurring dispute arbitration and collectively known as the half-life effect.
Answer the following statement true (T) or false (F)
______ methods of job evaluation break a job down into components like particular skills or abilities, and then they assign a number of points to each component based on its difficulty.
A. Rate range B. Pay structure C. Point-factor D. Equity theory
Which of the following is true about dividends?
A) Dividends are paid at the discretion of the shareholders. B) Dividends cannot be used for corporate purposes. C) Dividends are paid to shareholders who have sold their shares prior to the record date. D) Dividends once declared, cannot be revoked.
You want to buy a Nissan 300Z on your 27th birthday. You have priced these cars and found that they currently sell for $25,000. You believe that the price will increase by 10 percent per year until you are ready to buy
You can presently invest to earn 14 percent. If you just turned 20 years old, how much must you invest at the end of each of the next 7 years to be able to purchase the Nissan in 7 years? A) $8,881.21 B) $4,540.14 C) $4,652.18 D) $4,239.56 E) $5,072.09