Arun Kurmi

Arun Kurmi

  • NA
  • 104
  • 103.6k

stored procedure creation

Jun 14 2013 1:08 PM
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

Answers (2)