Stored Procedures - SQL Server

[suarve]

Hi,

Have been told by boss I have to use stored procedures for a particular online shop as I need to adhere to their business rules. I have heard of them before, pretty much know who they work basically but was just curious as to a few things. What are people's opinions of them as opposed to writing out a plain old SQL statement in my code (am usign ASP btw).

Have just been reading a bit about them and I'm told that they offer:

• Consistent, safe data modification
• Network bandwidth conservation

Can some kind soul explain the above two benefits, as I especially don't see how they conserve bandwidth.

Thanks