I have on master table in sql in which every time new data is inserted.i just want to copy the new inserted record into another table.How can i do this. below is my trigger but how can it identify only new records should be inserted into second table.please
help me and modify it.
CREATE TRIGGER CopyRecordToPortInTable ON SmsTable
SET NOCOUNT ON;
insert into Portintable(smsno,smstext,flag) select (sms,smstext,0) where condition
View Complete Post