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...

about triggers?

Answer Posted / balaji karpurapu

Trigger is a special kind of stored procedures,
Triggers are executed at the time of even takes
INSERT,UPDATE,DELETE actions.
1)Triggers are executed by attaching with table or view
2)Triggers are not stand alone executable

Triggers are classified into three types
1)DML Triggers
2)DDL Triggers
3)CLR Triggers

Syntax:

CREATE TRIGGER TRIGGER_NAME
ON TABLE/VIEW NAME
AFTER/INSTEAD OF
AS
BEGIN
---------
END

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between model view and controller?

894


What is viewbag?

998


Explain the tools used for unit testing in ASP.Net MVC

1105


How the ‘page lifecycle’ of ASP.Net MVC does works?

1123


Which version of the common language runtime (clr) does the .net framework 3.0 use?

1068


Do I need microsoft .net framework?

974


What is renderbody?

1008


Is .net core replacing .net framework?

958


When will the .net framework 3.0 be released?

942


What is Attribute Routing in ASP.Net MVC?

1083


what is use of entitydatasource control?

1065


What is rxjava used for?

1111


What is the significance of nonactionattribute?

1012


List out few different return types of a controller action method?

1030


What is the 'page life cycle' of an ASP.NET MVC?

1032