Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is stored procedure in SQL..??

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


Please Help Members By Posting Answers For Below Questions

what is create database syntax? : Sql server database administration

1104


How to create a ddl trigger using "create trigger" statements?

1131


What is the difference between a primary key and a unique key? Are they the same?

1077


What is a performance monitor?

976


where can you add custom error messages to sql server? : Sql server administration

1120


How to execute multiple stored procedures at one time in sql server?

1011


What is the latest version of microsoft sql server?

1045


What is data modification?

973


Why we use trigger in sql server with example?

959


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

1081


What are binary string data types in ms sql server?

1290


How can you check the level of fragmentation on a table?

1045


What are the types of dml?

978


What do you mean by authentication modes in sql server?

1083


What is candidate key with example?

975