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
CREATEPROCEDURE[dbo].[nb_order_insert]( @o_buyeridint , @o_idbigint OUTPUT ) AS BEGIN SET NOCOUNT ON; IF(EXISTS(SELECT*FROM[Shop]WHERE[s_id]=@o_shopid)) BEGIN INSERTINTO[Order](o_buyerid ) VALUES (@o_buyerid ) SET@o_id=@@IDENTITY RETURN1 — 插入成功返回1 END ELSE RETURN0 — 插入失败返回0 END