Answer / ramesh babu kollu

In a database management system (DBMS), a stored procedure
is a set of Structured Query Language (SQL) statements with
an assigned name that's stored in the database in compiled
form so that it can be shared by a number of programs. The
use of stored procedures can be helpful in controlling
access to data (end-users may enter or change data but do
not write procedures), preserving data integrity
(information is entered in a consistent manner), and
improving productivity (statements in a stored procedure
only need to be written one time).

Answer / rajeshbargode

Stored procedure is set of SQL statements

can you any body tell me suppose database is suspect mode. how can take to normal?

2 Answers   Teledata,

---

How can I check that whether automatic statistic update is enabled or not?

0 Answers  

---

What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

0 Answers  

---

which one will take 1st priority in case of insert statement and select statement???

2 Answers   HCL,

---

What are the advantages of policy management?

0 Answers  

---

Explain in brief about Microsoft SQL server?

0 Answers  

---

Explain different backup plans?

0 Answers  

---

what are the advanced features in sql 2008?

2 Answers   Wipro,

---

What are the new data types are introduced in sql 2000?

0 Answers  

---

Why would you use sql agent?

0 Answers  

---

What are indexes? When do you need to create Indexes?

4 Answers   CarrizalSoft Technologies, HP,

---

What is a trigger what are the advantages of trigger?

0 Answers  

---