Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Insert a record in a table, which has identity column
Message
From
25/02/2003 10:45:31
Sergey Berezniker
New York, United States
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Re: Insert a record in a table, which has identity column
Miscellaneous
Thread ID:
00757536
Message ID:
00757568
Views:
24
This message has been marked as a message which has helped to the initial question of the thread.
>How the statement would look like to preserve identity column?
insert into CreditInfo (< field list >) select * from CWebCreditLoad
Where, < field list > is a list of all columns excluding identity column in the same order as in SELECT column list.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform