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 a Stored Procedure?

Answer Posted / nivedita

Stored procedures are "defined once, used many times."A
stored procedure is written using Transact-SQL (T-SQL). T-
SQL is a subset of ANSI SQL-92 that has extensions to the
Standard. T-SQL includes variables, conditional logic,
loops and flow control.A stored procedure allows you to put
code or business logic on the database server.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between stored procedure and functions?

1064


What is the significance of master, tempdb and model databases?

1025


Can truncate be rolled back?

886


What is a cube? : sql server analysis services, ssas

947


Suggest a method of joining two tables.

1104


What stored by the master? : sql server database administration

1030


What are the different type of replication in sql server?

935


What is sql server replication? : sql server replication

925


What is sub-query in sql server?

1141


Explain aggregate functions?

1029


How to create a dynamic cursor with the dynamic option?

971


Explain primary key?

902


Explain what is the purpose of sql profiler in sql server?

1011


What are the main differences between #temp tables and @table variables and which one is preferred?

1015


what are the Prerequisites for Replication?

11242