Stored Procedure Variable

[tbailey922]

Hello,
How you declare variables to use with a SQL Server stored procedure? I am performing some calculations and need to return the results to a variable, and do some other calculations on that variable. Also can you pass variables from vb.net to a stored procedure?

Thanks
Tim

 

[mrdenny]

The syntax for the procedure is

create procedure dbo.usp_proc
   @Var1 varchar(10),
   @Date datetime
as
{code goes here}
go

Then run the procedure like this:

exec dbo.usp_proc @Var1='test', @Date='01/12/2003'

Denny

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