PDA

Click to See Complete Forum and Search --> : Database trigger in MS SQL SERVER


daljeet
Oct 13th, 1999, 02:36 PM
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.

JHausmann
Oct 14th, 1999, 12:01 AM
Use the "deleted" pseudo table, as in:

Select deleted.colname