What is the difference between constraints and triggers?
Answer Posted / vampire007
I dont' think Triggers are performanc wise more superior to
constraints. Constraints are isolated to table level
whereas triggers are flexible to do the validation on any
number of tables.
| Is This Answer Correct ? | 6 Yes | 5 No |
Post New Answer View All Answers
What are the 3 types of schema?
What does executeupdate return?
What do you understand by physical_only option in dbcc checkdb?
What new changes are being made in SQL Server?
Data table as parameter in sql server?
What is self contained sub query?
Why do we use trigger?
What is query parameter in ssrs?
What is normalization according to you and explain its different levels?
What happens if the update subquery returns no rows in ms sql server?
What are the advantages of paper records?
What is partitioned view?
Can I run multiple instances of sql server 2000 at the same time on one computer?
What is replication with database mirroring? : sql server database administration
What is extent? Types of extents?