what is trigger . hw will it use them
Answers were Sorted based on User's Feedback
Answer / m.ramarathna
Triggers are special kind of stored procedure that get
executed automatically when insert,update,delete operation
takes place on a table. Trigger can't be invoked on demand.
when delete,update,insert one data in the table ,that data
will stored in another one table.Nobody can't open the table
.That can open only by the select user.because of trigger
we give full importants to all data .
Is This Answer Correct ? | 10 Yes | 2 No |
Answer / sanjay kumar dinda
Trigger is a procedure which is invoked automatically when
any DML operation occured on a table.
At the time of DML operation , inside trigger SQL provide
the dummy table ( inderted , deleted) , which stores the
errected rows....
Is This Answer Correct ? | 2 Yes | 0 No |
What are tasks?
What is SQL Profiler what is the use of it?
2 Answers 247Customer, Steria,
Explain throw statement in sql server 2008?
How to change the name of a database user?
What sql server means?
how insert selected column only ?
Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table?
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
Define candidate key, alternate key, composite key.
13 Answers Infosys, Software India,
I am learning Testing, so i want to learn SQL also because SQL is important for Testing. I want to know which is best Institute in Ameerpet or SR Nagar or any other place in Hyd? Please help me.
What is meant by datasource?
Define compound operators?