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
Examples where you have worked on your own and as part of a team.
What is 'fish pond analysis' with respect to software testing?
please help! Smoke Test Checklist for Gmail
Does anybody used Visio in QA.If so, can u please explain where and when u used visio diagrams
Explain 3 high priority test cases for the performance of MSN search engine.
Explain system testing?
When should configuration management procedures be implemented?
What is meant by Regression testing? Differentiate Sanity and Regression testing?
What is the difference between debugging and testing?
What do you mean by automated testing?
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.
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?
How will you recognise if a case is a 'test case'?
What is software failure?
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