差异如图：
更新方式
/****** Object: StoredProcedure [dbo].[bsp_getorderbyosn] Script Date: 01/13/2015 10:12:00 ******/
DROP PROCEDURE [bsp_getorderbyosn]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [bsp_getorderbyosn]
@osn char(30)
AS
BEGIN
SET NOCOUNT ON;
SELECT [oid]
,[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]
FROM [bsp_orders] WHERE [osn]=@osn;
END
GO
/****** Object: StoredProcedure [dbo].[bsp_getorderbyoid] Script Date: 01/13/2015 10:12:00 ******/
DROP PROCEDURE [bsp_getorderbyoid]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [bsp_getorderbyoid]
@oid int
AS
BEGIN
SET NOCOUNT ON;
SELECT [oid]
,[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]
FROM [bsp_orders] WHERE [oid]=@oid;
END
GO
