数据库篇之存储过程[bsp_getorderbyosn]和[bsp_getorderbyoid]（非官方版本）

差异如图：

更新方式

/****** 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