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

来源：互联网发布：电脑语音同声翻译软件编辑：程序博客网时间：2024/06/18 15:31

差异如图：

更新方式

/****** Object:  StoredProcedure [dbo].[bsp_getorderbyosn]    Script Date: 01/13/2015 10:12:00 ******/DROP PROCEDURE [bsp_getorderbyosn]GOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROCEDURE [bsp_getorderbyosn]@osn char(30)ASBEGINSET 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;ENDGO/****** Object:  StoredProcedure [dbo].[bsp_getorderbyoid]    Script Date: 01/13/2015 10:12:00 ******/DROP PROCEDURE [bsp_getorderbyoid]GOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROCEDURE [bsp_getorderbyoid]@oid intASBEGINSET 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;ENDGO

0 0