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 is in place upgrade in sql server?
How to perform key word search in tables?
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
What stored by the msdb? : sql server database administration
How display code or Text of Stored Procedure using Sql query in Sql Server ?
What method is used by the Command classes to execute SQL statements that return single values?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
What is the recommended total size of your memory optimized tables?
What is an example of a foreign key?
While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
How do you implement session management in SQL Server mode?
What is stretch database in sql server?
How to return the date part only from a sql server datetime datatype?
How to delete exactly duplicate records from a table?
What are orphan records?
