Answer Posted / raji
Triggers are basically used to implement business rules.
Triggers is also similar to stored procedures.
The difference is that it can be activated when data is
added or edited or deleted from a table in a database.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is equi join with example?
How would you use user_constraints table in DB?
Tell me what are the essential components of sql server service broker?
How can I create a report based on a query? : sql server management studio
What is normalization? Describe its different types.
When would you use the stored procedures or functions?
Explain what are the restrictions that views have to follow? : SQL Server Architecture
What is nolock?
Show Practically Sql Server Views are updatable?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
How to use the inserted and deleted pseudo tables?
What are cursors stored procedures and triggers?
How are the unique and primary key constraints different?
What is store procedure? How do they work?
Tell me what is log shipping?