Posted by pbd22 on 06/04/07 19:19

Hi.

Like the title says - how do i do this?

I was given the following example:

INSERT INTO TABLE2 SELECT * FROM TABLE1 WHERE COL1 = 'A'

The above statement threw the following error:

An explicit value for the identity column in table 'TABLE2' can only
be specified when a column list is used and IDENTITY_INSERT is ON.

Then, after filling in all the column names in my above select
statement I kept getting an error to the effect that the number of
source and destination columns don't match. This is because one column
"confirm_hash" does not exist in the destination table, just the
source table.

could somebody show me how to get this to work?

thanks!

PS - MS SQL SERVER EXPRESS 2005

• Next in forum: Nulls in columns additions when 1 or more column values is blank
• Prev in forum: Re: How to distinguish operation type in trigger?
• Thread view: Copy Row Of Data From Table to Table In Same DB

[Reply to this message]