Interested to Buy Any Domain ? << Click Here >> for more details...
What is Stored procedure ?
- 4 Answers
- 10800 Views
- IBM, iGate, Inspira Technologies, I also Faced
- E-Mail Answers
Answer Posted / nitin bisht
A stored procedure is a group of Transact-SQL statements
compiled into a single execution plan.
Stored procedures return data in four ways:
* Output parameters, which can return either data (such
as an integer or character value) or a cursor variable
(cursors are result sets that can be retrieved one row at a
time).
* Return codes, which are always an integer value.
* A result set for each SELECT statement contained in
the stored procedure or any other stored procedures called
by the stored procedure.
* A global cursor that can be referenced outside the
stored procedure.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
can u combine pipeline parallelism and partition parallalism? how and whan?
What is the difference between a stored procedure and a query?
Is database a hardware or software?
What is a trace file?
Explain buffer manager?
What are the most common databases?
What is ase database?
First input columns brand, mt, re values are ov, 1,re vg, 2,re wu ,3,re. Second input columns are brand, mt, cx their records are ov,4,vg ,5,cx Wu, 6,cx and third input columns brand, mt, rt values are ov,7,rt vg, 8,rt wu, 9,rt but my output is brand, re, cx,rt values are ov, 1,4,7 vg, 2,5,8 wu, 3,6,9
How concurrency problems effect the database?
What are different types of data models available? Explain with example?
Display the employees whose salary is less than average salary.
Explain entity set?
How to do Data integrity testing? Who does this testing (Developer or tester)?
How do database connections work?
What is database bounce?
