摘要:
1.OUPUT参数返回值 例: 向Order表插入一条记录,返回其标识 CREATEPROCEDURE[dbo].[nb_order_insert]( @o_buyeridint , @o_idbigint OUTPUT ) AS BEGIN SET NOCOUNT ON; BEGIN INSERTINTO[Order](o_buyerid ) VALUES (@o_buyerid ) SET@o_id=@@IDENTITY END END 存储过程中获得方法:DECLARE@o_buyeridint DECLARE@o_idbigint EXEC[nb_order_insert]@o_buy 阅读全文