Answer Posted / 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 |
Post New Answer View All Answers
what is create database syntax? : Sql server database administration
How to create a ddl trigger using "create trigger" statements?
What is the difference between a primary key and a unique key? Are they the same?
What is a performance monitor?
where can you add custom error messages to sql server? : Sql server administration
How to execute multiple stored procedures at one time in sql server?
What is the latest version of microsoft sql server?
What is data modification?
Why we use trigger in sql server with example?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
What are binary string data types in ms sql server?
How can you check the level of fragmentation on a table?
What are the types of dml?
What do you mean by authentication modes in sql server?
What is candidate key with example?