Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

SELECT * INTO Table without propagating IDENTITY attribute? Expand / Collapse
Author
Message
Posted Thursday, January 3, 2013 9:22 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, October 22, 2014 12:08 PM
Points: 363, Visits: 2,341
Thank you, Scott! With the addition of a WHERE clause on the first SELECT, I end up with an empty table without a IDENTITY property, which is EXACTLY what I was looking for. Prefacing the * with my additional control columns doesn't mess up the solution, either. SSC rules!


Post #1402442
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse