What is stored procedure in SQL..??
Answers were Sorted based on User's Feedback
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 |
Stored procedure is set of SQL statements
Is This Answer Correct ? | 0 Yes | 0 No |
diffrence between function and procedure
What is scheduled job and how to create it?
What is the difference between having clause and where clause in sql server?
What is your recommendation for a query running very slow? : sql server database administration
What are differences in between sql server 2012 and sql server 2016?
What is normalization process?
What are the advantages of policy management?
What is the need for indexing?
What is the largest component inside a field?
What are “lost updates”?
How to create a user name in a database?
What are the features of Embedded SQL