Re: Sql loop Statement hi, Identity_Insert
Allows explicit values to be inserted into the identity column of a table. SET IDENTITY_INSERT [ database_name . [ schema_name ] . ] table { ON | OFF } database_name
Is the name of the database in which the specified table resides.
schema_name
Is the name of the schema to which the table belongs.
table
Is the name of a table with an identity column. |