<div>
if you have an identity column on b_dupe table you should also set the identity insert as...<br />
<br />
SET IDENTITY_INSERT b_dupe ON <br />
<br />
INSERT INTO b_dupe<br />
SELECT *<br />
FROM a_dupe<br />

</div>


if you have an identity column on b_dupe table you should also set the identity insert as...

SET IDENTITY_INSERT b_dupe ON

INSERT INTO b_dupe
SELECT *
FROM a_dupe


<div>
Actually if you have an IDENTITY column you need to explicitly name all your columns. &nbsp;Also, don't forget to turn off INDENTITY_INSERT once done.
</div>


Actually if you have an IDENTITY column you need to explicitly name all your columns.  Also, don't forget to turn off INDENTITY_INSERT once done.

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
i would like to copy everything from talbe a_dupe to b_dupe<br />
<br />
thanks
</div>
</div>


Hi

i would like to copy everything from talbe a_dupe to b_dupe

thanks

copy from one table to another

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.