Which is better in performance - CONSTRAINT or TRIGGER over
a column which restricts say an input of particular value
in a column of a table?
Answer Posted / guest
Constraint is better in terms of performance for same
operation. Why??
Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
Why we use trigger in sql server with example?
What is an execution plan?
Define model database?
How to disable a login name in ms sql server?
Explain what is lock escalation?
Is the order of columns in the set clause important in ms sql server?
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
How many triggers are possible per table?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What will be the maximum number of indexes per table?
Do you know what is difference between stored procedure and user defined function?
How each E-R model constructs can be mapped to the relational model?
What is the difference between for xml raw and for xml auto?
What is query cost in sql server?
What are different types of statement?