Interested to Buy Any Domain ? << Click Here >> for more details...
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
What does COMMIT command do?
Why use “pivot” in sql server?
What is a mixed extent?
Define magic tables in sql server?
What is meant by datasource?
Can I save my report as html, excel or word? : sql server management studio
What is table level trigger?
How do you clear a log file?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
How to create a view on an existing table in ms sql server?
Explain timestamp datatype?
What is the Difference Between Primary and Foreign Key?
What are the indexes in sql server?
Differentiate between sql temp table vs table variable?
How much is a sql server license?
