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
How do you implement session management in SQL Server mode?
What is normalization? Describe its different types.
Is it possible to update the views? If yes, how, if not, why?
What are the differences between stored procedure and the dynamic sql?
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
Describe how to use linked server?
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
What is de-normalization and what are some of the examples of it?
Name some of the open source software that you can use in alternative to SSR?
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
Do you know sql server 2008 backup compression?
What is a synonym for manipulation?
What are sub reports?
What is simple indexing method?
