触发器，根据具体业务写弹窗提示

USE [XXXXX]
GO
/****** Object:  Trigger [dbo].[trg_Biz_Samp_19]    Script Date: 2016/4/22 9:58:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
--------先接收任务再样品领取,结果登记提示--------------
ALTER trigger [dbo].[trg_Biz_Samp_19] ON [dbo].[biz_Samp]
AFTER insert,UPDATE 
AS
BEGIN
   IF UPDATE(SampStatusId)
   BEGIN
      declare @batchid uniqueidentifier = newid();


 BEGIN TRAN
 
 INSERT INTO GNotification(GContent, GNavigateUri, BizId, CreateBatchId)
      SELECT '您有新的待办事项【结果登记】: ' , 'f103015' ,INSERTED.SampId, @batchid  
 FROM INSERTED 
 INNER JOIN DELETED ON DELETED.SampId = INSERTED.SampId 
 left join biz_DeptTask on biz_DeptTask.TaskId = INSERTED.TaskId
 


 WHERE 
 INSERTED.SampStatusId != DELETED.SampStatusId   
 and INSERTED.SampStatusId = 420
 and exists(select 1 from biz_DeptTask where TestStatusId >= 310  )
 --and INSERTED.TaskId = biz_DeptTask.TaskId)                            ----确保是