Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

can I identify the trigger within the trigger code?

Status
Not open for further replies.
manohars

manohars

Programmer
Feb 28, 2004
97
US
Suppose, I write a single trigger for all the transactions, INSERT, UPDATE, DELETE. Is it possible to identify, which trigger(INSERT, UPDATE or DELETE) fires this trigger code?

Thanks in Advance,
Manohar
 
Sort by date Sort by votes
You could check the number of rows in the inserted and deleted tables. If inserted is 0 then it's a delete, if deleted is 0 then it's an insert if both have records, it's an update.

Questions about posting. See faq183-874
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Steve Yu
  • Locked
  • Question
How secure is MS SQL on the Internet vs behind firewall inside a LAN 1
Replies
3
Views
613
Chris Miller
Chris Miller
peac3
  • Locked
  • Question
fill the gap of hierarchy data
Replies
11
Views
1K
Chris Miller
Chris Miller
grnzbra
  • Locked
  • Question
Create Function Within IF statement. 1
Replies
4
Views
1K
mikrom
mikrom
leifoet
  • Locked
  • Question
How can I update the input of a form (rows and columns) to the database in one query ?
Replies
1
Views
413
Chris Miller
Chris Miller
BobThornton
  • Locked
  • Question
Drop a table based on the count of records in another table
Replies
13
Views
771
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top