Results 1 to 2 of 2

Thread: Database trigger in MS SQL SERVER

  1. Oct 13th, 1999, 02:36 PM #1
    daljeet
    daljeet is offline

    Thread Starter
    Junior Member
    Join Date
    Oct 1999
    Posts
    23

    Post

    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.
    Reply With Quote Reply With Quote
  2. Oct 14th, 1999, 12:01 AM #2
    JHausmann
    JHausmann is offline
    Frenzied Member
    Join Date
    Aug 1999
    Location
    Santa Clara, Ca , 95058
    Posts
    1,105

    Post

    Use the "deleted" pseudo table, as in:

    Select deleted.colname
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width