copy a row except an identity column

[vincer]

I have a table with an identity column and under a certain condition I want to change the value in the identity column.

Is there a simple sql statement that I can use regardless of the number of columns, that will insert all but the identity column from another entry in the same table.
Basically I don't want to name the columns in case a new column is added at a later date and the code doesn't get updated.
Many thanks

V

 

[tlbroadbent]

There is no simple statement. You must either code the column names or use dynamic SQL. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.