Answer Posted / ramanirajan das
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.
Because store procedure is pre complied so it need not compile
when u r doing some operation in procedure.
purpose:
Stored procedures reduce network traffic, secure 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 ? | 0 Yes | 0 No |
Post New Answer View All Answers
Do you know what is blocking?
What are the difference between “where” and “having” clause in sql server?
How to perform key word search in tables?
Explain tables in SQL Azure?
What is de-normalization and what are some of the examples of it?
What is the command used to recompile the stored procedure at run time?
How to optimize stored procedures in sql server?
Where to find ntwdblib.dll version 2000.80.194.0?
What do you understand by a view?
How to update multiple rows with one update statement in ms sql server?
why would you call update statistics? : Sql server database administration
What is simple indexing method?
What is the purpose of optimization?
What stored procedure can you use to display the current processes?
Explain what is the main purpose of having conversation group?
