USE [ViewRex]
GO
/****** Object:  Trigger [dbo].[REMOVE_TRASH]    Script Date: 2015-05-01 오후 1:02:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[REMOVE_TRASH]
   ON  [dbo].[Patient]
   AFTER INSERT
AS 
    
BEGIN
    DECLARE @PATIENTID VARCHAR(50)

    SELECT @PATIENTID = PATIENTID FROM INSERTED

    UPDATE PATIENT SET LASTNAME = REPLACE(lastname, '$)C', '') WHERE PATIENTID = @PATIENTID

END

 

 


오늘:
0
어제:
0
전체:
0