Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / satish kanaujia
A stored procedure is a named group of SQL statements that
have been previously created and stored in the server
database. Stored procedures accept input parameters so that
a single procedure can be used over the network by several
clients using different input data. And when the procedure
is modified, all clients automatically get the new version.
purpose:
Stored procedures reduce network traffic and improve
performance. Stored procedures can be used to help ensure
the integrity of the database.
e.g. sp_helpdb, sp_renamedb, sp_depends etc.
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
What is ssl in sql server?
Can we use custom code in ssrs?
Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security
What is compound operators?
What happens if null values are involved in string operations?
Explain the commands in sql server?
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
How to insert data with null values?
how many layers of tcp/ip protocol combined of? : Sql server database administration
What is code near application topology?
What are the advantages dts has over bcp?
Explain why variables called the most powerful component of ssis?
What do you mean by an execution plan?
How to see existing views in ms sql server?
Tell me what is the stuff and how does it differ from the replace function?
