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
END

DECLARE @o_buyerid int
DECLARE @o_id bigint
EXEC [nb_order_insert] @o_buyerid,@o_id output

CREATE PROCEDURE [dbo].[nb_order_insert](
@o_buyerid int ,
@o_id bigint OUTPUT
)
AS
BEGIN
SET NOCOUNT ON;
IF(EXISTS(SELECT * FROM [Shop] WHERE [s_id] = @o_buyerid ))
BEGIN
 INSERT INTO [Order](o_buyerid ) VALUES (@o_buyerid )
 SET @o_id = @@IDENTITY
 RETURN 1 ― 插入成功返回1
END
ELSE
 RETURN 0 ― 插入失敗返回0 END

DECLARE @o_buyerid int
DECLARE @o_id bigint
DECLARE @result bit
EXEC @result = [nb_order_insert] @o_buyerid ,o_id output

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

CREATE TABLE [dbo].[Temp](
[o_id] [bigint] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
[o_buyerid] [int] NOT NULL
)
INSERT [Temp] EXEC [nb_order_select] @o_id
主站蜘蛛池模板： 宾川县| 宿州市| 合作市| 忻州市| 龙山县| 通州市| 通化市| 夏河县| 尚义县| 蒙山县| 荃湾区| 伊川县| 扎赉特旗| 临海市| 肥乡县| 新田县| 桂阳县| 深州市| 西乡县| 镇巴县| 宁城县| 凤山市| 犍为县| 新丰县| 神池县| 高青县| 民权县| 门头沟区| 烟台市| 米林县| 常山县| 灵宝市| 阜康市| 濮阳县| 林口县| 修水县| 郴州市| 凌海市| 铜梁县| 滁州市| 治县。|