View Single Post
  #8 (permalink)  
Old 05-06-2008, 02:28 AM
bluesky bluesky is offline
D-Web Analyst
 
Join Date: Jun 2007
Posts: 201
bluesky is on a distinguished road
Default 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.
Reply With Quote