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
主站蜘蛛池模板： 鄂托克旗| 肥东县| 赤城县| 佳木斯市| 嘉义市| 合肥市| 林西县| 曲靖市| 寿宁县| 屯昌县| 密云县| 民权县| 莱阳市| 兴安盟| 辽阳市| 玛多县| 太湖县| 彩票| 桐乡市| 澄江县| 怀仁县| 大悟县| 北川| 左权县| 南京市| 临澧县| 昆明市| 富源县| 象州县| 佛山市| 荥阳市| 天峨县| 高平市| 广安市| 五大连池市| 酒泉市| 通许县| 汉源县| 贵阳市| 玛曲县| 伽师县|