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 IDENTCURRFNT 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 IDENTITYINSERT OFF
Statements iii and iv arecorrect and statements and if are incorrect
Statements and ri are correct and statementsili and ware incorrect
Statements i ii and iii are correct and statement is incoirect.
Statements i ii and iv are correct and statement in is incorrect
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
