获取存储过程返回值及代码中获取返回值
摘要:1.OUPUT参数返回值例: 向Order表插入一条记录,返回其标识CREATEPROCEDURE[dbo].[nb_order_insert](@o_buyeridint,@o_idbigintOUTPUT)ASBEGINSETNOCOUNTON;BEGININSERTINTO[Order](o_buyerid)VALUES(@o_buyerid)SET@o_id=@@IDENTITYENDEND存储过程中获得方法:DECLARE@o_buyeridintDECLARE@o_idbigintEXEC[nb_order_insert]@o_buyerid,o_idbigint2.RETURN过
阅读全文
posted @
2013-06-04 15:37
jameshappy
阅读(547)
推荐(0)