how to insert value in identity column in sqlserver
----------------INSERT VALUE IN IDENTITY COLUM
SET IDENTITY_INSERT EMPLOYEE ON INSERT INTO EMPLOYEE(EID,ENAME,EADD) VALUES(1,'SHIVAM','JHANSI/NEW DELHI') SET IDENTITY_INSERT EMPLOYEE OFF
--------------------------------
No comments:
Post a Comment