Answer Posted / koti-khammam
Trigger is a special type of stored procedure that will
fire automatically when ever data modifications like
INSERTIONS,UPDATIONS or DELETIONS occurs on the table.
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
Do you have any idea about the tcl commands?
How do I create a trace in sql server?
What do you mean by an execution plan? Why is it used?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
List the various tools available for performance tuning?
Explain tablesample?
Explain sub-query?
How much memory that we are using in Logshipping Concept?
What are the disadvantages of primary key and foreign key in SQL?
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?
Is resultset an interface?
Can the query output be sorted by multiple columns in ms sql server?
What is linked report?
What are logical/boolean operations in ms sql server?
What is the difference between NOROW and LOCKROW?
