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

Find 2nd Highest salery in emp table Select* from emp where &n= select * count from emp where (salery >=emp.salery) Enter n value 2 These query is correct or not. Tell me any other methods.

6 Answers  

---

What are the options which must be set to allow the usage of optimistic models?

0 Answers  

---

What are the characteristics of modern DBMS?

0 Answers   Ericsson,

---

what is a correlated sub-query? : Sql server database administration

0 Answers  

---

Does any body please help me what question's have asked for SSRS in the interview?

0 Answers  

---

Does group by or order by come first?

0 Answers  

---

How to create view in stored procedure sql server?

0 Answers  

---

What is log in sql server?

0 Answers  

---

What are the character string functions supported by sql server 2005?

0 Answers  

---

create table with fields ID, reserved_by,res_date res_date is datefield like 2010-03-09 00:00:00.000 from 2005 to 2006 any date assume based on res_date need to slect table and display based on month (full jan details in database irrespective of date and year

3 Answers  

---

Why functions are used in sql server?

0 Answers  

---

Can we write a distributed query and get some data which is located on other server and oracle database?

0 Answers  

---