What is the difference between constraints and triggers?
Answer Posted / nageswarao
Constraints are predefined business rules in which all the
organisations follow this constraints without any
modification.
trigger is a user defined business rule for which user is
responasible for logic for business rule
| Is This Answer Correct ? | 9 Yes | 6 No |
Post New Answer View All Answers
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
How do you drop an index?
What is normalization and what are the advantages of it?
What do you understand by integration services in sql server?
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
What is cursors? And what are the different types of cursor?
What are the essential components of sql server service broker?
What is check constraint in sql server?
After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas
How to transfer an existing table from one schema to another schema in ms sql server?
Why the trigger fires multiple times in single login?
What is mssql?
How to stop log file growing too big?