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

What is query and its types?

0 Answers  

---

What is the language structure to add a record to a table?

0 Answers  

---

Can I know,how to Execute Funcion and Trigger through command(Manualy Execution) in MS SQL/SERVER 2005,give me answer with Example.

1 Answers  

---

Explain the difference between functions and stored procedures in sql server?

0 Answers  

---

How does a profiler work?

0 Answers  

---

---

how to retrive only second row from table in sql server 2000?

15 Answers   Cognizant, CTS,

---

How will you hide an attribute? : sql server analysis services, ssas

0 Answers  

---

Define the term DML, DDL and DTL?

1 Answers  

---

Explain isolation levels that sql server supports?

0 Answers  

---

What are different types of constraints?

0 Answers  

---

How many database files are there in sql server 2000?what are they?

0 Answers  

---

What is a view and what are its advantages?

0 Answers  

---