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

Difference between writing SQL query and stored procedure ?

Answer Posted / senthil kumar

compared with query, stored procedure is efficient and fast
execution.Because stored procedure is program once it
formed then execute as a program.

Is This Answer Correct ?    90 Yes 26 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are date and time data types in ms sql server?

1017


Can you leave a union at any time?

999


What is postgresql server?

940


Explain try...catch with sql server?

980


List the advantages of using stored procedures?

996


you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

905


explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

883


How do I make a resultset scrollable?

908


How to find the list of fixed hard drive and free space on server?

1096


Explain having clause?

908


Can we take the full database backup in log shipping?

898


What is mssql?

927


Do you know how to send email from database?

926


What are the differences between DDL, DML and DCL in SQL?

1169


What is nolock hint in sql server 2008

1071