Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

How many types of TRIGGERS are there in MS SQL Server?

Question Posted / devipriyanka

Answer Posted / devipriyanka

Types of Triggers

* DML(data manipulation language) triggers (SQL Server
2000- 80.0)
o AFTER triggers (Only Tables)
o INSTEAD OF triggers (Tables or Views)
* DDL(data definition language) triggers (SQL Server
2005- 90.0)
* SQLCLR triggers (SQL Server 2005- 90.0)

Is This Answer Correct ?    13 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is update_statistics command?

1065

How many databases Microsoft SQL server provides?

1087

What is simple indexing method?

1031

Tell about MOM Tool(Microsoft Operator Manager)?

1914

Where do we use trace frag?

1015

you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

1249

What are the indexes in sql server?

1114

How does stuff differ from the replace function?

1010

Define Unique Key?

1003

In what sequence sql statement is processed?

1012

Does windows server 2016 come with sql server?

932

Where cross join is used?

960

Which are the new data types introduced in sql server 2008?

879

What are the advantages to use stored procedures?

1109

Why use triggers?

1014