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 does recursive cte works in sql server?
What stored procedure would you use to view lock information?
What is the difference between clustered index and primary key?
What are the various Operating system files that every SQL server 2005 database has and what is the purpose.
How secure is sql server database?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
What is buffer cash and log cache in sql server?
How can we get count of the number of records in a table?
Differentiate between a having clause and a where clause.
How to declare a cursor with "declare ... Cursor" in ms sql server?
List the different types of collation sensitivities in sql server?
Does index speed up select statements?
What is row_number()?
What is an inner join?
what are the core components of SSRS?
