TRIGGER ALTERNATIVE FOR DELETE

CREATE TABLE #testing
([Name] VARCHAR(50))
INSERT #testing
VALUES('Raemsh')
INSERT #testing
VALUES('Sateesh')
INSERT #testing
VALUES('Madhu')
GO
CREATE TABLE #HoldDeleteData
([Name] VARCHAR(50))

DELETE FROM #testing
OUTPUT DELETED.* INTO #HoldDeleteData
WHERE [Name]='Madhu'


SELECT *FROM #HoldDeleteData

Comments

Popular posts from this blog

System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out

Pre login Handshake or Connection Timeout Period

Transparent Data Encryption(TDE) with Master Key and Certificate in SQL Server