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
Explain what is dbcc?
What is Extended user-defined?
System variable and temporary variables
What is meant by datasource?
Define union, union all, minus, intersect?
How to change the password of a login name in ms sql server?
Explain go command in sql server?
Explain what are the basic functions for master, msdb, model, tempdb databases?
Suggest a method of joining two tables.
How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?
What are acid properties of transaction?
What is difference between count (*) and count column?
What are the mathematical functions supported by sql server 2005?
What are the components of sql server service broker?
What is provisioning, billing and metering, and connection routing concepts in the service layer?