What is the difference between constraints and triggers?
Answer Posted / malini paul
1.Constraint is a statement about a database that is always
true.Whereas triggers constrain what a transaction can do.
2.Constrain applies to existing data in the table and any
statement that manipulates the table.Whereas Trigger does
not apply to data loaded before the trigger was created.
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
What is the purpose of the master database?
What is purpose of normalization?
what is checksum in sql server.........???
Tell me what is de-normalization and what are some of the examples of it?
How you can add messages to the nt event log from within a stored procedure?
Explain different types of index?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
What are scheduled tasks in sql server?
What are ddl (data definition language) statements for tables in ms sql server?
What are the advantages of user-defined functions over stored procedures in sql server?
How to delete multiple rows with one delete statement in ms sql server?
How to create sub reports?
What are exact numeric data types in ms sql server?
When does a workload on SQL Azure get throttled?