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

How can I return string result from action in asp.net mvc?

1001


Is http stateful or stateless?

969


How we can register the Area in ASP.Net MVC?

1055


What is partialview in asp.net mvc?

1004


What is needed for running an application built on winfx on the .net framework 3.0?

887


What does a viewmodel do?

960


How to enable Attribute Routing?

1061


Is .net framework going away?

972


Can you please explain the request flow in ASP.NET MVC framework?

1063


i just want to write an exam regarding .net?plz give me information about taking a test?where to pay 4 d exam,exam centre?

2182


What is associationset? : Entity framework

999


What are the advantages of mvc over asp.net?

971


Explain the new features added in version 4 of mvc (mvc4)?

941


Why is the .net framework 3.0 a major version number of the .net framework if it uses the .net framework 2.0 runtime and compiler?

967


What is the difference between partial and renderpartial?

878