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?
- 3 Answers
- 11537 Views
- Accenture, I also Faced
- E-Mail Answers
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
Differentiate between truncate vs delete in mssql?
What is the sql server 2000 version number?
Where sql server user names and passwords are stored in sql server? : sql server database administration
What are the different Topologies in which Replication can be configured?
What are the steps you should follow to start sql server in single-user mode?
Explain Geography datatype in SQL Server
What are points to remember while using the fillfactor argument?
What are the differences between decimal and float in ms sql server?
When you should use a low fill factor?
What are 3 ways to get a count of the number of records in a table?
How to transfer data from a cursor to variables with a "fetch" statement?
How exceptions can be handled in sql server programming?
What is key attribute?
What are pessimistic lock and optimistic lock?
Which are the third-party tools used in sql server and why would you use them?
