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
can an automatic recovery be initiated by a user? : Sql server administration
What is the difference between clustered and a non-clustered index?
What is the status of services on passive node for failover cluster in sql server? : sql server database administration
what are user defined datatypes? : Sql server database administration
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
What are the restrictions while creating batches in sql server?
How can you hide the sql server instances?
What are sql servers used for?
Explain about Joins?
How do I run sql server 2014?
Does dbcc checkdb requires db to be in single_user mode? : sql server database administration
What are types of subqueries?
How to enter date and time literals in ms sql server?
What is page-level compression?
How to execute a sql statement using mssql_query()?
