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...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What is stored procedure in SQL..??

Question Posted / paragsgn

Answers were Sorted based on User's Feedback



What is stored procedure in SQL..??..

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

What is stored procedure in SQL..??..

Answer / rajeshbargode

Stored procedure is set of SQL statements

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

can you instantiate a com object by using t-sql? : Sql server database administration

0 Answers  

What are the difference between data length and length in SQL Server-2008?

3 Answers   Scio Healthcare,

What do you mean by collation recursive stored procedure?

0 Answers  

What is database isolation in sql server? : sql server database administration

0 Answers  

What are different types of statements that are supported by sql?

0 Answers  

What is difference between clustered index and non clustered index?

0 Answers  

What do we need queues in sql service broker?

0 Answers  

How can count the string ? for ex: If i have string like 'bhaskar' then i need like b:1 h:1 a:2 s:1 k:1 r:1 please give any idea on that

9 Answers   TCS,

What are the extra roles available in msdb? : sql server security

0 Answers  

Using the customer, and order table in northwind database, please write a query to produce xml?

0 Answers  

How to delete database objects with "drop" statements in ms sql server?

0 Answers  

What is a trigger?

7 Answers  

For more SQL Server Interview Questions Click Here
Categories