Triggers

คำสั่งลบแถว

ลบครั้งละหลายแถวแล้วนำผลมาแสดง

ALTER TRIGGER LogTriggerforCustomers2

ON Customers

AFTER DELETE

AS

DECLARE @CustomerID CHAR(5)

DECLARE cursorVar CURSOR SCROLL FOR

SELECT CustomerID FROM DELETED

OPEN cursorVar

WHILE @@FETCH_STATUS = 0

BEGIN

FETCH NEXT FROM cursorVar INTO @CustomerID

INSERT dbo.Log

VALUES (GETDATE(),SUSER_SNAME(), USER,

'DELETED','Customers',@CustomerID)

FETCH NEXT FROM cursorVar INTO @CustomerID

END

CLOSE cursorVar

DEALLOCATE cursorVar

 

DELETE Customers where CustomerID ='00009'or CustomerID='00002'

 

select * from Customers