I am doing an sql query on a database that has 4 columns. (using sql server)
column names:
Date [smalldatetime],Varnum [smallint],Value [float],TextValue [nvarchar](50).
so I make a stored procedure to run this query, here is the stored procedure:
now, I call this stored procedure in the sql query analyzer like this:Code:CREATE PROCEDURE [dbo].[seek] (@Date [smalldatetime], @VarNum [smallint], @Value [float] OUTPUT, @TextValue [nvarchar](50) OUTPUT ) AS SELECT @Value=Value, @TextValue=TextValue FROM datatbl WHERE Date=@Date and VarNum=@VarNum RETURN GO
but the values that I have print out of the variables (last 2 lines) are nothing.Code:declare @value [float], @textvalue [nvarchar](50) execute seek @varnum=1, @date='1/1/2001', @value=1, @textvalue='' print @value print @textvalue
Does anyone know how to get the output variables when calling a stored procedure? If not in sql, then how do I do it in VB?




Does anyone know how to get the output variables when calling a stored procedure? If not in sql, then how do I do it in VB?
Reply With Quote