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

What is Trigger?

Question Posted / honeysukumar

Answers were Sorted based on User's Feedback



What is Trigger?..

Answer / koti-khammam

Trigger is a special type of stored procedure that will
fire automatically when ever data modifications like
INSERTIONS,UPDATIONS or DELETIONS occurs on the table.

Is This Answer Correct ?    11 Yes 0 No

What is Trigger?..

Answer / kaushik chatterjee

A trigger is some what simillar to stored procedure. It is
written to perform a set of predefined actions when a
perticular database objecy such as tables,views are
DELETED,INSERTED,UPDATED.
Triggers are implicitly called and are NOT instactiated by
the user. Once written, it will be called automatically by
the DBMS engine when a UPDATE/DELETE/INSERT operation is
performed on the database object for which the trigger is
intended or written.
Triggers can be written for any one of the 3 operations
written above or all of them.

Is This Answer Correct ?    6 Yes 0 No

What is Trigger?..

Answer / pawan378

above answers are correct.
let me add some thing.

Trigger
(Pre - Trigger) is a dynamic Rule that should be done before
Data modification Happens.
or
(Post - Trigger) is a Consequent step that should be taken
as soon as the Data Happens.

Is This Answer Correct ?    5 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is the difference between for xml raw and for xml auto?

0 Answers  

Explain the advantages of merge replication?

0 Answers  

What are “phantom rows”?

0 Answers  

What is surrogate key? : sql server analysis services, ssas

0 Answers  

What is not null constraint?

0 Answers  

What is normalization in Database ?

4 Answers  

What is cursor ? And what is difference between Trigger ?

3 Answers   HCL, Polaris,

What do you mean by recursive stored procedure?

0 Answers  

How you can change the database name in SQL SERVER?

0 Answers  

Syntax to find the used space and free space of the Data file in a database(SQL Server). Following queries didn't give the exact Used space and Free Space Information sp_spaceused;DBCC showfilestats;exec MyDbName.dbo.sp_spaceused;SP_HELPFILE Can any one tell me the query for how to find the exact used data file space and free space in a Data File?

2 Answers   Cognizant,

What are the transaction properties?

0 Answers  

what is hash table

3 Answers   ILFS, Teledata,

For more SQL Server Interview Questions Click Here
Categories