คำสั่งลบแถว

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

ALTERTRIGGER 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