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 |
What are unicode character string data types in ms sql server?
What does Master database contains?
what's the difference between a primary key and a unique key? : Sql server database administration
What is the purpose of the master database?
What is system stored procedures?
What is mscorsvw.exe - process - microsoft .net framework ngen?
How do you make a trace?
How can change procedure in sql server?
How to drop an existing schema in ms sql server?
How do I find the size of a sql server database?
How to locate and take substrings with charindex() and substring() functions?
What is difference between order by and group by?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)