Explain in a brief trigger and its types?

1.	Explain in a brief trigger and its types?
Answer» A trigger is used for EXECUTING the batch of MsSQL CODES. This is done when commands LIKE INSERT, UPDATE or DELETE are executed against a sequence of the table. Whenever the DATA gets modified this command automatically gets triggered. Its types are- INSERT UPDATE INSTEAD OF DELETE

Answer»

A trigger is used for EXECUTING the batch of MsSQL CODES. This is done when commands LIKE INSERT, UPDATE or DELETE are executed against a sequence of the table. Whenever the DATA gets modified this command automatically gets triggered.

Its types are-

INSERT
UPDATE
INSTEAD OF
DELETE

Discussion

No Comment Found

Related InterviewSolutions

What do you understand by TABLESAMPLE?
Explain the purpose of Floor and Sign functions?
Name some of the logical operators used in MsSQL.
Explain collation recursion and its procedure?
Explain in a brief trigger and its types?
Explain the utility of MSSql?
Explain the features of MSSQL?
Can you explain the effective functioning of MSSql?
Elaborate sub query along with its properties?
What do you understand by MSSql?

Explain in a brief trigger and its types?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment