What is the difference between constraints and triggers?
- 9 Answers
- 34189 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
How does stuff differ from the replace function?
How do you improve the performance of a SQL Azure Database?
What is the default value of an integer data type in sql server 2005?
What are number line correlation administrators will use while working with a subquery?
Mention the differences between substr and charindex in sql server.
How to delete duplicate rows?
Is it possible to create trigger on views?
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
How many instances per computer are there in sql server 2000?
How to view existing indexes on an given table using sys.indexes?
What is the difference between clustered and non-clustered indexes in ms sql server?
Difference between group by clause and having clause in SQL?
What do you understand by recursive stored procedure?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
how to create a scrollable cursor with the scroll option? : Sql server database administration
