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
If the job running very slow what is the action you do
Can another user execute your local temporary stored procedures?
How do I trace a query in sql server?
Explain DBCC?
What do you mean by sql server agent?
can a database be shrunk to 0 bytes, if not, why? : Sql server administration
How to bind a view to the schema of the underlying tables?
What are the properties of the transaction?
Explain something about security and SQL Azure?
How to execute a sql statement using mssql_query()?
How to receive output values from stored procedures?
What do you understand by a view? What does the with check option clause for a view do?
Write a sql query to sort on different column name according to the parameters passed in the function?
how would you improve etl (extract, transform, load) throughput?
what's the information that can be stored inside a bit column? : Sql server database administration