Answer Posted / babu
stored procedure is PL SQL statement that is called by a name
procedure perform a task, they does not return value.
1.reduce network traffic
2.reduce server overhead
3. Excution plan may be reused
4.provide good security for our data
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
can any body tell me how to know the password of current user in sql server
Why should one not prefix user stored procedures with ‘sp_’?
What is RMS migrations?
What is the recursive stored procedure in sql server?
What is parameterized reports in ssrs ?
Explain the concepts and capabilities of sql server?
What is normalization? Explain different forms of normalization?
What is difference between unique and primary key?
What does Master database contains?
What are window functions in sql server?
What is 5nf in normalization form?
Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?
Where the sql logs gets stored? : sql server database administration
Explain rdbms?
What Is Rdbms?
