Stored Procedure

Question

hi friends,
i know syntax of stored procedure
but what are the place were write it-sql server mgmt studio or server explorer in VS,or .cs file of code. and how to use it
please provide solution step by step

for ex. i have a syntax for stored procedure below. where write this and how to use this....
suppose i want store text of TextBox1 on btn1 click

Create procedure InsertProc(
@name as string)
as
insert into user_tbl(name)values(@name)
go