http://searchwindevelopment.techtarget.com/tip/0,289483,sid8_gci1270321,00.html

Hope that helps.
Fernando L Rodriguez, MCP

You can think of a stored proc as a prefefined set of instructions. These
can be called  by setting up a command object with the parameters required
by the stored proc. If you use the wizards for generating a datasource on
your page, this will give you the option to add a stored proc and set up
your parameters. For example, you may have a stored proc called highest
score which looks at all the players who play and how many goals they score.
The parameters you pass could be something like.  @FixtureDate , @TeamName
etc and it could return  a table of  top scoring players for a team or all
teams.

You can optionally use SQL Server Management Studio to manage your database,
with some simplier operations available from within visual studio itself.

HTH