Message
 
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
01640153
Message ID:
01640155
Views:
48
>You don't have to create a trigger for each column. One trigger per table can handle all columns in it.
>

I didn't know that. Thank you.

But still, I have about 90 tables in the database. Not all of them will need a trigger but say, maybe half of them. Is this reasonable?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Previous
Next
Reply
Map
View