Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 trigger sequencing

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-04-25 : 08:13:20
vijay writes "hi to sql team

query regarding sequencial trigger

i have 22 dufferent table and i have written trigger for all the
table seperately
for inser update and delete trigger in one single table

i want to insert the data according to field name

so how can i do it through trigger can you just help me"

nr
SQLTeam MVY

12543 Posts

Posted - 2005-04-27 : 15:54:02
Do you mean you are creating an audit trail (not really clear).
see
http://www.mindsdoor.net/SQLTriggers/AuditTrailTrigger.html

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -