Output
SELECT * FROM DERS
--TABLO DEGISKENLERI OLUSTURULDU
DECLARE @DERS TABLE
(
DERS_ID VARCHAR(50),
AD VARCHAR(50),
DERS_OGR VARCHAR(50)
)
DELETE FROM DERS
OUTPUT deleted.DERS_ID,
deleted.AD,
deleted.DERS_OGR
WHERE AD='YAZILIM'
SELECT * FROM @DERS
-----------------------------
BEGIN TRANSACTION
SELECT * FROM DERS
--TABLO DEGISKENLERI OLUSTURULDU
DECLARE @DERS TABLE
(
DERS_ID VARCHAR(50),
AD VARCHAR(50),
DERS_OGR VARCHAR(50)
)
DELETE FROM DERS
OUTPUT deleted.DERS_ID,
deleted.AD,
deleted.DERS_OGR
WHERE DERS_OGR='MURAT'
SELECT * FROM @DERS
ROLLBACK