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 |
How to use subqueries in the from clause in ms sql server?
How to generate create procedure script on an existing stored procedure?
What are four major operators that can be used to combine conditions on a where clause?
What are difference between Cluster index and Non-Cluster index?
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,...
7 Answers ADP, Satyam, Tech Mahindra,
List all types of constraints in sql server?
how to do partition in sqlserver
What are the types of resultset?
how can we know that how many users are connected in perticuler server??????
How to create a simple stored procedure in ms sql server?
How much is a sql server license?
Oracle (3259)
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)