Question: Consider the statements given below and choose the correct option, with respect to IDFNTITY in SQL Server: i . An Identity column must not allow

Consider the statements given below and choose the correct option, with respect to IDFNTITY in SQL Server:
i. An Identity column must not allow NULL values
ii. IDENT_CURRFNT returns the last inserted identlty value for a table in any session
iii. @@IDENTITY returns the first Inserted value among a group of INSERT statements
iv. The identity columin value can be explicitly inserted using the statement SET IDENTITY-INSERT OFF
Statements iii and iv arecorrect and statements /and if are incorrect
Statements 1 and ri are correct and statementsili and ware incorrect
Statements i, ii and iii are correct and statement N is incoirect.
Statements i, ii and iv are correct and statement in is incorrect
Consider the statements given below and choose

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!