[dba-SQLServer] TRIGGER question

Arthur Fuller artful at rogers.com
Mon Jul 11 19:27:05 CDT 2005


Yup. Stoopid me. Trusting the Outlook compiler again.

A.

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Michael
Maddison
Sent: July 11, 2005 8:24 PM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [dba-SQLServer] TRIGGER question

Susan,

I think Arthur got it slightly wrong.  '#' denotes a temp table. 
Just use inserted/deleted.

BTW you can use QA to debug triggers by creating an sp that will trigger
the trigger and
when you debug the sp it will step into the trigger...  HTH

cheers

Michael M





More information about the dba-SQLServer mailing list