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

A type of integration testing in which software elements, hardware elements, or both are combined all at once into a component or an overall system, rather than in stages.

1140


What is test environment?

1169


I need to learn everything I can about what a Waterfall approach vs. an Agile approach looks like in QA Testing. What is the best online resource?

1143


Which one of the following activities is the most efficient and most cost effective at identifying defects? 1. Prototyping 2. Unit test 3. Beta test 4. Design/code inspection 5. Risk analysis

2125


What is total quality management?

1098


Why is incremental integration preferred over 'big bang' integration?

1358


What is meant by Regression testing? Differentiate Sanity and Regression testing?

2464


Please Check out and Answer the Questions in Networking section. It's argent.

2261


What is CDB?

2118


How would you estimate the amount of re-testing likely to be required?

1273


What is independent test group (itg)?

1343


Explain good design?

1133


What is validation and verification testing?

1122


what are Link Speed available for FCOE SAN?

2013


What is web application testing

2301