CREATE TRIGGER addtomsgdown ON [dbo].[TABLE1]
FOR INSERT
AS
declare @usernumber as varchar(11)
declare @messagecontent as varchar(200)
declare @senddate as datetime
select @usernumber=username,@messagecontent=message from inserted
insert into .yingxian.dbo.TABLE2(usernumber,messagecontent,opdate) values(@usernumber,@messagecontent,getdate())