sql express keyword to identify new row

[dandamudi padma]

i am having one database and the data will be comming through a device and i need to copy the newly generated row to another database how is it possible i need to insert new row into another database this to be done in sql express can anybody give solution for this padma padma

[pmarfleet]

Run an INSERT...VALUES query to insert a new row of data into a table in your second database.

Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush

[dandamudi padma]

i need to write trigger for this

[pmarfleet]

Good for you.

Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush

[Pete OHanlon]

You want to look at syntax like this:

create trigger dbo.MyTrigger
on dbo.MyTable
for insert
as 
insert into database2.dbo.table2 (col1, col2) 
select col1, col2 from inserted
end

Deja View - the feeling that you've seen this post before.

My blog | My articles