How can I retrieve the value of a column from the 'deleted table', created just after the delete operation in MS SQL SERVER 6.5
Actually I'm trying to acquire the value of the field, the row of which I'm deleting in a database trigger.
Printable View
How can I retrieve the value of a column from the 'deleted table', created just after the delete operation in MS SQL SERVER 6.5
Actually I'm trying to acquire the value of the field, the row of which I'm deleting in a database trigger.
Use the "deleted" pseudo table, as in:
Select deleted.colname