Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Learned something today? Share it, or learn from what others have learned today

KEEPIDENTITY in SQL SERVER

Oct 7 2011 5:11AM by Robert Dennyson   

KEEPIDENTITY applicable only in an INSERT statement when the BULK option is used with OPENROWSET. Specifies that the identity value or values in the imported data file are to be used for the identity column. If KEEPIDENTITY is not specified, the identity values for this column are verified but not imported and the query optimizer automatically assigns unique values based on the seed and increment values specified during table creation.

Here is the Example

INSERT INTO HumanResources.myDepartment
   with (KEEPIDENTITY)
   (DepartmentID, Name, GroupName, ModifiedDate)
   SELECT *
      FROM  OPENROWSET(BULK 'C:\myDepartment-n.Dat',
      FORMATFILE='C:\myDepartment-f-n-x.Xml') as t1;
Read More..   [13 clicks]

Published under: SQL Server Tips ·  ·  ·  · 


Robert Dennyson
11 · 14% · 4430
0
Liked
 
0
Knew
 
0
Learned
 
0
Incorrect
 
0
Interesting
 
0
Forgotten



Submit

Your Comment


Sign Up or Login to post a comment.

"KEEPIDENTITY in SQL SERVER" rated 5 out of 5 by 19 readers
KEEPIDENTITY in SQL SERVER , 5.0 out of 5 based on 19 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]