Trigger code reference book

• Carol Behrmann

  Newbie

  Points: 1

  More actions

  April 14, 2006 at 8:00 am

  #168641

  Greetings,

  I've got to write a reasonably complicated SQL Server 2000 trigger.   I've written a few Sybase triggers but found out the hard way that I don'thave a clue as to what I'm doing in SQL Server.  The only SQL Server triggers I have access to are simple, with only a line or 2 of code. 

  Is there a text book, a web-site or reference out there with syntax and documentation?   Hopefully, also some tips on debugging the suckers?

  Thanks,

  Carol

• sushila

  SSC-Dedicated

  Points: 35293

  More actions

  April 14, 2006 at 8:05 am

  #632624

  Your best bet would be to start within BOL itself...it has pretty extensive (& comprehensive) documentation on triggers..

  
  
  
  
  
  
  **ASCII stupid question, get a stupid ANSI !!!**

• michanne

  SSCrazy

  Points: 2329

  More actions

  April 16, 2006 at 11:57 pm

  #632726

  I learned from Advanced TSQL (ben-gan,moreau): http://www.apress.com/book/bookDisplay.html?bID=72