Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between constraints and triggers?
- 9 Answers
- 36628 Views
- Wipro, I also Faced
- E-Mail Answers
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 is lock escalation and what is its purpose?
Will count(column) include columns with null values in its count?
State the difference between union and union all?
John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?
What is dirty page?
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
What is the difference between value type and reference type?
What is a schema in ms sql server 2005?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
Can another user execute your local temporary stored procedures?
How to convert numeric expression data types using the cast() function?
What are the restrictions that views have to follow?
What are user defined functions in ms sql server?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
What is the difference between ddl,dml and dcl commands?
