Question

在存储过程中，动态SQL的返回值怎么取得

Answer 1

1.OUPUT参数返回值
CREATE?PROCEDURE?[dbo].[nb_order_insert](
@o_buyerid?int?,
@o_id?bigint?OUTPUT
)
AS
BEGIN
SET?NOCOUNT?ON;
BEGIN
INSERT?INTO?[Order](o_buyerid?)
VALUES?(@o_buyerid?)
SET?@o_id?=?@@IDENTITY
END
END2.存储过程中获得方法：
DECLARE?@o_buyerid?int
DECLARE?@o_id?bigint
DECLARE?@result?bit
EXEC?@result?=?[nb_order_insert]?@o_buyerid?,o_id?output?3.SELECT 数据集返回值
CREATE?PROCEDURE?[dbo].[nb_order_select](
@o_id?int
)
AS
BEGIN
SET?NOCOUNT?ON;
SELECT?o_id,o_buyerid?FROM?[Order]
WHERE?o_id?=?@o_id
GO

Answer 2

老媪种莲藕