trigger is a block of code that constitutes a set of T-sql statements act

Tell me about Triggers?

Question Posted / shalini

Answer Posted / shalini

trigger is a block of code that constitutes a set of T-sql
statements activated to response in certain action.

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

role of sql sever 2005 in database rather than any other database

1987

What is a join in sql? What are the types of joins?

1188

What is the use of commit?

1057

What is the language structure to add a record to a table?

1073

What is log shipping? Can we do logshipping with SQL Server 7.0 ?

1048

What do you understand by the denormalisation?

1018

What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

1060

What are the different types of stored procedures?

1155

how many no of arguments can be passed in procedures and functions

5640

What is difference between index seek vs. Index scan?

1199

How do you send email on SQL Server?

1115

Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

1123

Explain various On-Delete options in a DB table. Which is the default option?

1531

Can foreign key be deleted?

978

Explain what are page splits? : SQL Server Architecture

1119