CAN ANY SOLVE THIS PROBLEM - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

CAN ANY SOLVE THIS PROBLEM

Author

Topic

DURGESH
Posting Yak Master

105 Posts

Posted - 2008-07-17 : 05:31:28

hi all,
i have two 2 databases

i want to insert a record with identity column in tbl2 of database2
using trigger

trg_insert
insert into database2.dbo.tbl2 select * from insert

i need the comments
regards
durgesh j

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-07-17 : 05:36:29

insert into database2.dbo.tbl2(column list that excludes identity column) select required_columns from insert

Madhivanan

Failing to plan is Planning to fail

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-07-17 : 12:02:48

can you refrain from using caps in your headings please?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources