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

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What are the advantages of using stored procedures? Please
don't simply say compilation time will be saved as they are
already complied. Please specify some other advantages.

Question Posted / srikanth

Answers were Sorted based on User's Feedback



What are the advantages of using stored procedures? Please don't simply say compilation time ..

Answer / paras

If your database resides on one server and you are accessing
it from different place then using Stored Procedure reduces
network traffic because you are just passing its name and
few parameters (if any)across the network instead of long query.

Is This Answer Correct ?    6 Yes 0 No

What are the advantages of using stored procedures? Please don't simply say compilation time ..

Answer / santosh kumar sharma

You can encapsulate your business logic in SP. Easy to
maintain as any changes in the business logic, you'll just
have to alter the SP and not your application.

Is This Answer Correct ?    2 Yes 0 No

What are the advantages of using stored procedures? Please don't simply say compilation time ..

Answer / pradip jain

Become secure program from sql Injection.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL Server Interview Questions

How to retrieve range of 10th rows to 20 th rows from total rows from a database table.? (Not from Dataset)

10 Answers   Cognizant, Infosys,

How do database indexes work?

0 Answers  

what is the maximum size of a row in sql server 2000 and 2005

2 Answers  

write a query to remove duplicate records without using primary key column?

2 Answers   ABCO,

What are sparse columns?

0 Answers  

How to delete duplicate records based on single column from a table?

0 Answers   Petranics Solutions,

What are extended events in sql server?

0 Answers  

plz send every query in sql server2000

1 Answers   Infosys,

How to disable triggers using "disable trigger"?

0 Answers  

Explain the difference between primary keys and foreign keys?

0 Answers  

What is sql or structured query language?

0 Answers  

Explain the difference between functions and stored procedures in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories