Notes

USE [Drama]
GO
/****** Object: Trigger [dbo].[CustModLog] Script Date: 2018/1/24 上午 11:30:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
ALTER TRIGGER [dbo].[CustModLog]
ON [dbo].[Cust]
AFTER INSERT,DELETE,UPDATE
AS
BEGIN
SET NOCOUNT ON;
if(Select Count(*) From inserted) > 0 and (Select Count(*) From deleted) = 0
begin
--新增

end
if(Select Count(*) From inserted) = 0 and (Select Count(*) From deleted) > 0
begin
--刪除

end

if(Select Count(*) From inserted) > 0 and (Select Count(*) From deleted) > 0
begin

DECLARE @tmpTable Table (CustIdx int);
DECLARE @ParmDefinition NVARCHAR(4000);

INSERT INTO @tmpTable
SELECT CustIdx from inserted

WHILE EXISTS(SELECT TOP 1 CustIdx from @tmpTable)
BEGIN


DELETE FROM @tmpTable WHERE CustIdx = @CustIdx;
--Select @CustIdx
End

end
END