Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Insert values from all fields except for one
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Re: Insert values from all fields except for one
Miscellaneous
Thread ID:
00762778
Message ID:
00762786
Views:
17
If you are trying to keep the identity column in the new table in tact then you can't bulk copy but you can do an insert select. ex.

INSERT INTO .. ( FROM SELECT FROM ..)
Thanx,
Bill Elvin
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform