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 loop testing?

609


What is a user guide?

602


What are the categories of defects?

612


Explain static analysis?

601


Could anyone let me know what exactly is telecom testing & how is it done? And also how is mainframe testing done?

1519






What is recovery/error testing?

599


What is api (application programming interface)?

613


What is the difference between test scenarios and test strategy?

553


Best institute for protocol testing in Hyderabad ? How will be the market for protocol testing ?

1795


What is disaster recovery testing?

590


How will you hack someone's gmail or yahoo account.

1733


Mention what the difference between pilot and beta testing is?

576


Hi do any one has dumps for ISTQB or ISEB exams for august or september exam 2013. Pleae mail qazwsx2631981@yahoo.co.in

1845


What is vdd - version description document?

596


I got an offer from TCS as a software engineer, But it says I will work for TCS BPO, Is there any difference in policies of TCS BPO and TCS-IT Services.How is the Working enviornment and appriasal procedure

1682