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
What is software fault?
Explain the term bug.
What are different SCSI command phases?
Explain verification?
how to download fullversion of JIRA(defect reporting s/w) s/w for free.can any provide web site for full version free download.
what is the most challenging situvation r u phased while during testing?
What is parameter?
Explain exhaustive testing?
What is user documentation?
What is a user manual?
Mention what are the categories of defects?
what is the difference between 8.2 and 9.2 versions of qtp tool
What the basic components of defect report format are?
Explain what test deliverables is?
Explain audit?