数据库语句收集
获取每个类别最新记录：

CREATE TRIGGER singletri  ON dbo.tbl_SMSendTask  INSTEAD OF INSERT asBEGINdeclare @tablename varchar(20)declare @sqlcom nvarchar(500), @param nvarchar(500)declare @Daddr varchar(20)declare @scon varchar(500)declare @stime datetimedeclare @num  intselect  @Daddr=DestAddr,@scon=SM_Content,@stime=SendTime  from insertedset @tablename='tbl_SMResult_'+SUBSTRING(CONVERT(varchar(100), GETDATE(), 12),3,4)set @sqlcom='select @a=count(*) from '+@tablename+'  where  DestAddr=@Daddr  and SM_Content=@scon  and DATEDIFF(hh,SendTime,@stime)<=5'set @param = '@Daddr varchar(20),@scon varchar(500),@stime datetime,@a int output'exec sp_executesql @sqlcom,@param,@Daddr,@scon,@stime,@num output insert into tbl_SMSendTask(CreatorID,SmSendedNum,OperationType,OrgAddr,DestAddr,SM_Content,SendTime,NeedStateReport,ServiceID,FeeType,FeeCode,SMType,MessageID,DestAddrType,SubTime,TaskStatus,SendLevel,SendState,tryTimes,SendType,taskName)  select CreatorID,SmSendedNum,OperationType,OrgAddr,DestAddr,SM_Content,SendTime,NeedStateReport,ServiceID,FeeType,FeeCode,SMType,MessageID,DestAddrType,SubTime,TaskStatus,SendLevel,SendState,tryTimes,SendType,taskName from inserted ins where @num<=0insert into sms_history (OrgAddr,DestAddr,SM_Content,SendTime,SubTime,ServiceID) select OrgAddr,DestAddr,SM_Content,SendTime,SubTime,ServiceID from Inserted where @num>0      END  GO