how to create a stored procedure with example code

Hi Gopi,

Please refer the below links

http://www.functionx.com/sqlserver/Lesson35.htm

http://www.4guysfromrolla.com/webtech/111499-1.shtml

Thanks