Home » Posts tagged "insert values in auto increment column"

Tag Archives: insert values in auto increment column

Setting Identity Insert On/Off on Table – Sql Server


This command is from SQL Server. This command is designed to enable users to set their own value for identity column in case they want. This is very useful for us. We use it in MERGE and RDA if we insert the client to send to the server where we want to make sure to insert row on the server with the IDENTITY value generated by the client. At any time, only one table in a session can have the [...]

Tags: , ,