What is stored procedure in SQL..??

Answers were Sorted based on User's Feedback



What is stored procedure in SQL..??..

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).

Is This Answer Correct ?    9 Yes 0 No

What is stored procedure in SQL..??..

Answer / rajeshbargode

Stored procedure is set of SQL statements

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

diffrence between function and procedure

5 Answers   Wipro,


What is scheduled job and how to create it?

0 Answers  


What is the difference between having clause and where clause in sql server?

0 Answers  


What is your recommendation for a query running very slow? : sql server database administration

0 Answers  


What are differences in between sql server 2012 and sql server 2016?

0 Answers  


What is normalization process?

0 Answers  


What are the advantages of policy management?

0 Answers  


What is the need for indexing?

0 Answers  


What is the largest component inside a field?

0 Answers  


What are “lost updates”?

0 Answers  


How to create a user name in a database?

0 Answers  


What are the features of Embedded SQL

0 Answers   HCL,


Categories