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

What are the different types of collation sensitivity in sql server?

0 Answers  

What are the different subsets of sql?

0 Answers  

What is the process of indexing?

0 Answers  

How to Generate a Series of Random Integers With T-SQL?

1 Answers  

What is sorting and what is the difference between sorting and clustered indexes?

1 Answers  

Can you use order by when defining a view?

0 Answers  

How to use transact-sql statements to access the database engine?

0 Answers  

Hi SQL gurus, i am working for an MNC... My team is having a problem in sql server. when user slects date prompts from jan 1st to april 30, it should display all months data like : jan aa feb bb mar cc but when it comes to april its taking data like : jan aa feb bb mar cc apr dd...and so on means its taking data again from jan to april which we dont want. we want the data only april month as we are getting jan, feb and mar... can any one write the code to relsove the issue please would be greatful if you can send to shiva_sans@yahoo.co.in and also please send your email also ...so that we will be in touch for any kind of queries ... Thanks a lot in Advance !!!

1 Answers  

Define DML and DCL statements?

1 Answers   Hexaware, NIIT,

Explain about nested stored procedure?

0 Answers  

What is Peer to peer Replication?

1 Answers   CarrizalSoft Technologies, HCL,

What is a unique index?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories