TSQL - Variables -- :( Help me plz

[WMitchellCPQ]

Hi Helpful SQL coders,

Im behind on a deadline and would really appreciate some help. Im soberly new to T-SQL

I've a webserice calling a stored procedure to insert data.
Can someone show me an example on how to use variables in stored procedures.

This is as the fields affected by the call are differ.

Thanks in advance

 

[mrdenny]

create procedure procedure_name
   @var1 as varchar(10),
   @var2 as int
as
statements go here

To run this procedure

procedure_name @var1='testing', @var2=25

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[WMitchellCPQ]

Thanks Denny

Now to write those following statements

 

[mrdenny]

no probem.

Denny

--Anything is possible. All it takes is a little research. (Me)