How to insert data in identity column

rahulsingh725 · February 25, 2016, 4:36pm

i have 2 database both are same .
i want to insert one database table to another database table .
if there are identical column .
i m using script like
insert into [tablename]

select * from [databasename].dbo.tablename

djj55 · February 25, 2016, 4:46pm

Do not use the *. List the columns for both the insert and the select. If there is a identity column you will need to turn on identity insert.

rahulsingh725 · February 25, 2016, 4:48pm

any other way to insert in identy column. including * use

djj55 · February 25, 2016, 4:49pm

lookup SET IDENTITY_INSERT

rahulsingh725 · February 25, 2016, 4:52pm

i have used but not working when using * in query

ScottPletcher · February 25, 2016, 5:10pm

No, you cannot use IDENTITY_INSERT ON and * at the same time, it is just not allowed.

Kristen · February 27, 2016, 4:36pm

To save you typing all the column names you can query the database to get that list instead. Or you can just DRAG the table name into your code (in SSMS)