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 / anbu arunmozhi

Query execute every time when ever u call that statement
but stored procedure execute only one time v can used every time it should be very efficient compare query

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can sql servers link to other servers like oracle?

894


what are the reporting service components in SSRS?

170


How many types of functions are there in sql server?

984


What happens when converting big values to numeric data types?

1226


Which are ddl commands?

1113


When is update_statistics command used?

1087


What is the difference between an index and a unique index?

1044


What is difference between order by and group by?

1054


What are the steps to follow to configure SQL*Net?

1076


What is the difference between DataRow.Delete() and DataRow.Remove()?

1272


Which is faster statement or preparedstatement?

1001


How to count rows with the count(*) function in ms sql server?

1059


Why we use trigger in sql server with example?

1013


what is database replicaion? : Sql server database administration

1271


What is mscorsvw.exe - process - microsoft .net framework ngen?

1003