Interested to Buy Any Domain ? << Click Here >> for more details...
What is stored procedure in SQL..??
- 2 Answers
- 4788 Views
- I also Faced
- E-Mail Answers
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 modify the underlying query of an existing view?
What is a primary index?
What is the difference between function and stored procedure in sql server?
How to use subqueries with the in operators in ms sql server?
What is a view?
What are the advantages to use stored procedures?
Write a SQL query to make a column as unique?
What are user defined functions in ms sql server?
What are relationships and mention different types of relationships in the dbms
Please explain go command in sql server?
what is denormalization and when would you go for it? : Sql server database administration
What is sql server programming?
-
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)
