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
What do you understand by sql server agent?
What is perspective, have you ever created perspective? : sql server analysis services, ssas
Explain Geography datatype in SQL Server
Explain the commands in sql server?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
Explain steps of normalization?
What have included columns when we talk about sql server indexing?
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
Explain system scalar functions?
Can the “if update (colname)” statement be used in a delete trigger?
What are the pre-defined functions in the sql server?
on line cluster can we make if yes tell me the procedure
Why use sub query in sql server and list out types of sub queries?
how many layers of tcp/ip protocol combined of? : Sql server database administration
What do you mean by tablesample?