How to create Stored Prodedures in SQl Derver 2005?

[Williamjoe]

Hi Guys ,
I am new in Database Design field. I want to know how to create Stored Procedures in SQL Serve and What's the benefit of them?

[Addison123]

Its very easy..! Here is syntax of syntax of stored procedure

create procedure procedurename
as select * from tablename