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
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
What is a transact-sql statement?
how can u get last observation in an unknown dataset ?
Can we add a cpu to sql server?
What are click through reports?
What are the types of resultset?
What is an identity column in insert statements?
What is key set driven?
Explain what is public role in sql server?
Explain why variables called the most powerful component of ssis?
Can you name some of the dml commands in sql?
Do you know what is openxml in sql server?
What stored by the model? : sql server database administration
How to change the password of a login name in ms sql server?
When is update_statistics command used?