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
Explain encryption of entire databases without the need for application changes in sql server 2008?
Explain log shipping and mention its advantages.
What is acid mean in sql server?
What is difference between rollback immediate and with no_wait during alter database?
Does hive support indexing?
How to update a field in SQL after ALTERING a row?
How to Sync Two SQL Azure Databases?
Why do we backup Active Directory ?
What are the tool windows in sql server management studio? : sql server management studio
Call by value and call by reference in procedure and function, with NOCOPY.
How to create function with parameter in sql server?
What is the use of keyword with encryption.
What is normalization and denormalization in sql server?
Do you know what is bit data type and whats the information that can be stored inside a bit column?
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
