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
what are different types of raid configurations? : Sql server database administration
What is the stored procedure?
whats new about truncate in sql server 2008?
What is the use of sign function?
What's the information that can be stored inside a bit column?
Explain rdbms?
How display code or Text of Stored Procedure using Sql query in Sql Server ?
What is meant by indexing?
what is the difference between openrowset and openquery?
What is SQL Azure Firewall?
Tell me what is normalization? Explain different forms of normalization?
How to execute multiple stored procedures at one time in sql server?
What is 1nf 2nf and 3nf?
What is a domain constraint give an example?
What is table value parameters (tvp)?
