用返回值或者是out变量create procedure xxx ( @a int OUT ) as begin Declare @b set @b=@a RETURN @b end从参数中返回@a,从Return中返回@b
Dim Connstr As String = '连接字串' Dim sqlconn As New System.Data.SqlClient.SqlConnection(Connstr) Dim sqlcmd As New System.Data.SqlClient.SqlCommand Dim a as integer Dim b as integer a=1 sqlconn.Open() sqlcmd.Connection = sqlconn sqlcmd.CommandText = "xxx" sqlcmd.CommandType = Data.CommandType.StoredProcedure sqlcmd.Parameters.Add("@a", Data.SqlDbType.Int).Value = a sqlcmd.Parameters.Add("@Return", Data.SqlDbType.Int) sqlcmd.Parameters("@Return").Direction = Data.ParameterDirection.ReturnValue sqlcmd.ExecuteNonQuery() b = sqlcmd.Parameters("@Return").Value '释放对象 sqlconn.Dispose() sqlcmd.Dispose()
(
@a int OUT
)
as
begin
Declare @b
set @b=@a
RETURN @b
end从参数中返回@a,从Return中返回@b
Dim sqlconn As New System.Data.SqlClient.SqlConnection(Connstr)
Dim sqlcmd As New System.Data.SqlClient.SqlCommand
Dim a as integer
Dim b as integer
a=1
sqlconn.Open()
sqlcmd.Connection = sqlconn
sqlcmd.CommandText = "xxx"
sqlcmd.CommandType = Data.CommandType.StoredProcedure
sqlcmd.Parameters.Add("@a", Data.SqlDbType.Int).Value = a
sqlcmd.Parameters.Add("@Return", Data.SqlDbType.Int)
sqlcmd.Parameters("@Return").Direction = Data.ParameterDirection.ReturnValue
sqlcmd.ExecuteNonQuery()
b = sqlcmd.Parameters("@Return").Value
'释放对象
sqlconn.Dispose()
sqlcmd.Dispose()