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!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: tomjscribe
- Content: Threads
- Order by date
-
Trigger - How to tell operation type
Writing a generic trigger for all operations (Update, Insert, Delete). How can I tell what type of operation against the table has occurred. I want one, generic I/U/D trigger that needs slightly different behavior for each operation. Basically, I am writing an 'audit trail' trigger and need to...- tomjscribe
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
Trigger - How to get tablename
I want to create a generic trigger that KNOWS what table it is built against. I took a guess the @@tablename might be a system variable and hoped the following code would work: declare @tblname as char(50) select @tblname = @@tablename It did not. ANY CLUES. Again I want to write a generic...- tomjscribe
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Programming
