Sir,

What is the alternative to Oracle's command

insert into table2 (select * from table1)

I have got two table's in 2 databases. The first database is BCCI and the second database is TEST. The BCCI table contains one table HR_EMPMAS and contains data. There is the same table in the TEST database which is empty.

When I am firing the statement

INSERT INTO HR_EMPMAS SELECT * FROM BCCI.DBO.HR_EMPMAS

the following message is shown

Server: Msg 8101, Level 16, State 1, Line 1
An explicit value for the identity column in table 'HR_EMPMAS' can only be specified when a column list is used and IDENTITY_INSERT is ON.


Love, light and peace

INSERT INTO HR_EMPMAS (field1, field2,...)
SELECT (field1, field2,...) FROM BCCI.DBO.HR_EMPMAS

where field1,field.. are all the table columns( fields) without identity column

yep
shahchi1 is right

atul