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
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.
What is test environment?
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?
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
What is total quality management?
Why is incremental integration preferred over 'big bang' integration?
What is meant by Regression testing? Differentiate Sanity and Regression testing?
Please Check out and Answer the Questions in Networking section. It's argent.
What is CDB?
How would you estimate the amount of re-testing likely to be required?
What is independent test group (itg)?
Explain good design?
What is validation and verification testing?
what are Link Speed available for FCOE SAN?
What is web application testing