差异如图:
更新语句如下:
DROP PROCEDURE [bsp_createorder] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [bsp_createorder] @osn char(30) ,@uid int ,@orderstate tinyint ,@productamount decimal(18,2) ,@orderamount decimal(18,2) ,@surplusmoney decimal(18,2) ,@parentid int ,@isreview tinyint ,@addtime datetime ,@shipsn char(30) ,@shipsystemname char(20) ,@shipfriendname nchar(30) ,@shiptime datetime ,@paysn char(30) ,@paysystemname char(20) ,@payfriendname nchar(30) ,@paymode tinyint ,@paytime datetime ,@regionid smallint ,@consignee nvarchar(20) ,@mobile varchar(15) ,@phone varchar(12) ,@email varchar(50) ,@zipcode char(6) ,@address nvarchar(150) ,@besttime datetime ,@shipfee decimal(18,2) ,@payfee decimal(18,2) ,@fullcut int ,@discount decimal(18,2) ,@paycreditcount int ,@paycreditmoney decimal(18,2) ,@couponmoney int ,@weight int ,@buyerremark nvarchar(250) ,@ip varchar(15) AS BEGIN SET NOCOUNT ON; DECLARE @oid int; INSERT INTO [bsp_orders] ([osn] ,[uid] ,[orderstate] ,[productamount] ,[orderamount] ,[surplusmoney] ,[parentid] ,[isreview] ,[addtime] ,[shipsn] ,[shipsystemname] ,[shipfriendname] ,[shiptime] ,[paysn] ,[paysystemname] ,[payfriendname] ,[paymode] ,[paytime] ,[regionid] ,[consignee] ,[mobile] ,[phone] ,[email] ,[zipcode] ,[address] ,[besttime] ,[shipfee] ,[payfee] ,[fullcut] ,[discount] ,[paycreditcount] ,[paycreditmoney] ,[couponmoney] ,[weight] ,[buyerremark] ,[ip]) VALUES (@osn ,@uid ,@orderstate ,@productamount ,@orderamount ,@surplusmoney ,@parentid ,@isreview ,@addtime ,@shipsn ,@shipsystemname ,@shipfriendname ,@shiptime ,@paysn ,@paysystemname ,@payfriendname ,@paymode ,@paytime ,@regionid ,@consignee ,@mobile ,@phone ,@email ,@zipcode ,@address ,@besttime ,@shipfee ,@payfee ,@fullcut ,@discount ,@paycreditcount ,@paycreditmoney ,@couponmoney ,@weight ,@buyerremark ,@ip) SET @oid=SCOPE_IDENTITY(); SELECT @oid AS 'oid'; END GO