Download How to insert value into primary key column in SQL Server? book pdf free download link or read online here in PDF. Read online How to insert value into primary key column in SQL Server? book pdf free download link book now. All books are in clear copy here, and all files are secure so don't worry about it. This site is like a library, you could find million book here by using search box in the header.
Your query will be now: SET IDENTITY_INSERT Student ON; INSERT INTO Student VALUES('1','joedio','newyark',GETDATE()); SET IDENTITY_INSERT Student OFF; If you wants that SQL manage it self then default it set to IDENTITY_INSERT OFF and Auto increment is set, means on every insert the new value is assigned to that PK column.
Read : How to insert value into primary key column in SQL Server? pdf book online Select one of servers for direct link: |
---|