Interested to Buy Any Domain ? << Click Here >> for more details...
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
How do I shrink an ldf file?
What are click through reports?
What are various ways to enhance the ssrs report?
What is collation?
What are .mdf files?
What is the difference between truncate and delete commands?
Explain sql server service broker?
What is the language structure to add a record to a table?
Differentiate between ms sql server reporting services vs crystal reports?
Are resultset updatable?
How do I make a resultset scrollable?
What is an example of a primary key?
What are the different kinds of ssrs reports?
What is the use of for clause?
What are the system database in sql server 2005?
