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

Can truncate be rolled back?

946


What are the difference between clustered and a non-clustered index?

1043


Explain differences between web edition and business edition?

119


What are the different Authentication modes in SQL Server and how can you change authentication mode?

1086


Why people hate cursor?

1145


What is thr feature of change data capture?

980


What guidelines should be followed to help minimize deadlocks?

943


Tell me the use of keyword with encryption. Create a store procedure with encryption?

1008


What are the tables in sql?

1087


Explain the usage of floor function in sql server.

964


Explain what is dbcc?

1010


What is log cache in sql server?

1043


Define constraints and give an example of their use?

1040


How do you trace the traffic hitting a sql server?

1141


What is oltp (online transaction processing)?

1008