Answer Posted / satish kanaujia
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.
purpose:
Stored procedures reduce network traffic 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 ? | 4 Yes | 4 No |
Post New Answer View All Answers
How to list all user names in a database?
How can we solve concurrency problems?
How many columns can exist together per table?
What is a constant or literal in ms sql server?
how to create “alternate row colour”?
What are user-defined functions (udfs) in sql server?
What is the importance of three tier architecture?
How to read data in a table with "select" statements?
Is it possible to replicate data from sql server to oracle? : sql server replication
What is replication with database mirroring? : sql server database administration
What method is used by the Command classes to execute SQL statements that return single values?
How we can refresh the view?
How to verify the port number of the sql server?
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
State the difference between union and union all?
