Answer / arunyadav007

There are two type of stored procedures. System Stored
Procedure and User Stored Procedure (User Defined Stored
Procedure).

User SProcs serves the same purpose as the system SProcs.
Now the question comes what is the need to write a stored
procedure?
Suppose in your organization there are certain queries
which are used very frequently or there are certain queries
in which you don't want users to know that what all tables/
views etc. are scanned to get the desired result or, for
faster execution of a frequently used query you write
stored procedures.

Answer / hari

Stored procedure is nothing but a Set of T-Sql statements
combined to perform a single task of several tasks. it's
like a macro

Answer / 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.

Answer / 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 there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

0 Answers  

---

Can I run multiple instances of sql server 2000 at the same time on one computer?

0 Answers  

---

What is user-defined inline table-valued function?

0 Answers  

---

About DTS usage ?

2 Answers   Cognizant, Wipro,

---

What are the types of processing and explain each? : sql server analysis services, ssas

0 Answers  

---

Explain what stored procedure sp_replcounters is used for? : sql server replication

0 Answers  

---

What do you understand by a view? What does the with check option clause for a view do?

0 Answers  

---

Why we use functions in sql server?

0 Answers  

---

how we can use a database with php.

2 Answers   HCL, IT Solution,

---

What is read committed?

0 Answers  

---

Explain raiserror in sql server?

0 Answers  

---

What is the beast way to write CTE in SQL Server ?

0 Answers   HCL,

---