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 / komal sankhe

compared with sql query, stored procedure is efficient and
timesaving execution.Because stored procedure is program
once it formed then execute as a program at the same
time.coz queries are taking the time

Is This Answer Correct ?    19 Yes 22 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many columns can we include on clustered index ?

1058


What are the different types of replication are there in sql server 2000?

1087


Tell me what do we need queues in sql service broker?

1050


Why we use trigger in sql server with example?

1013


How you can get a list of all the table constraints in a database? : Sql server administration

1091


Does sql server use java?

1127


What are the different ways you can create databases in sql server?

1155


What's the information that can be stored inside a bit column?

1069


Explain error handling in ssis?

1070


What are the rules to use the rowguidcol property to define a globally unique identifier column?

1075


Explain tablesample?

1038


Tell me what is the difference between locking and multi-versioning?

1082


your distribution database is full what will u do

2217


What happens if you delete a table that is used by a view?

1061


in the physical file layout, where should the transaction log be stored in relation to the data file?

1040