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

what is trigger?
What is stored procedures?
What is a cursor?

Answer Posted / anwesha

1>Trigger is a store procedure that executes AUTOMATICALLY
to execute certain actions(insert\update\delete)
2types. . after(before commit opertion and it checked foregn
doesntkey constraint) and instead of(after commit opertion
and it doesnt checked foregn key constraint)

2>Store procedure set of trransactSQL statement.
its return val is mandatory
it may hav parameter(input and output)

3>Function also performs particular task
it alws returns a value.
while creation of table u can use function also as a member

Is This Answer Correct ?    9 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is software fault?

1013


Explain the term bug.

1144


What are different SCSI command phases?

2086


Explain verification?

1011


how to download fullversion of JIRA(defect reporting s/w) s/w for free.can any provide web site for full version free download.

2489


what is the most challenging situvation r u phased while during testing?

2235


What is parameter?

980


Explain exhaustive testing?

996


What is user documentation?

969


What is a user manual?

967


Mention what are the categories of defects?

970


what is the difference between 8.2 and 9.2 versions of qtp tool

2062


What the basic components of defect report format are?

932


Explain what test deliverables is?

907


Explain audit?

923