>>Hi everybody,
>>
>>Sorry for such naive question. If I want to insert data into the table, which has identity column, what can I do?
>>
>>Can I use statement similar to
insert into CreditInfo select * from CWebCreditLoad
, where CreditInfo would have one additional field (identity)?
>>
>>Thanks in advance.
>
>Nadya,
>
>You've to provide the list of columns for your INSERT statement. Sql Server matches columns from SELECT to INSERT by position not by name.
How the statement would look like to preserve identity column?
If it's not broken, fix it until it is.
My Blog