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

Examples where you have worked on your own and as part of a team.

2222


What is 'fish pond analysis' with respect to software testing?

986


please help! Smoke Test Checklist for Gmail

1903


Does anybody used Visio in QA.If so, can u please explain where and when u used visio diagrams

3069


Explain 3 high priority test cases for the performance of MSN search engine.

1142


Explain system testing?

993


When should configuration management procedures be implemented?

1193


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

2384


What is the difference between debugging and testing?

1159


What do you mean by automated testing?

1106


hai, i completed my B.Tech.i planning to join in testing tools.can anybody suggest me good institute.I heard about Nageshwara Rao sir institute for testing tools.Now which one is good so i can get job in testing tools. please help me.....where to join in hyd.

2076


What advantages would using an iSCSI Storage Area Network (SAN) give to your organization over using Direct Attached Storage (DAS) or a Fibre Channel SAN?

1766


How will you recognise if a case is a 'test case'?

1153


What is software failure?

1148


hi..I am from Pune and i want to take ISTQB.So pls tell me which book i should refer and sample papers?How much time i need to prepare for it?Those who have material pls help me out and mail me at pankaj_r_autela@yahoo.com , And those who are from Pune and have taken this exam ,i vl like to share your knowledge. Thanks in Advance to all of you.. Pankaj

2022