Answer Posted / jerry joseph
Trigger gets executed when an INSERT UPDATE or DELETE occurs
2 types of triggers are INSTEAD OF triggers and AFTER triggers
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is statement level trigger?
What is an index in sql?
what are the core components of SSRS?
What is data mart? : sql server analysis services, ssas
What is the name of the system variable that returns the number of rows affected by a SQL statement?
Explain primary key, foreign key and unique key?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
What are the advantages of stored procedure in sql server?
How would we use distinct statement? What is its use?
What do you understand by recursive stored procedure?
What are the extra roles available in msdb? : sql server security
how to use DTS package in 2000,2005,2008 in sql server
Can we insert data into view sql server?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
Define union, union all, minus, intersect?
