有些数据存在关仓库BUG运行语句
有些数据存在关仓库BUG运行语句： CREATE procedure Close_warehouse
@Items varbinary(1200),
@uid varchar(10)
AS
set nocount on
declare @ec int
set @ec=0
de万宇传奇论坛clare @stat int
declare @num int
select @stat=OpenExt ,@num=ExtCKNum from warehouse where AccountID=@uid
set @ec=@@error | @ecjjj行会封号
if @stat is not null --正常情况是不应该为空的
begin
if @stat=@num begin 网通传奇3私服--主仓库
UPDATE warehouse SET Items=@It找服网站ems wher架设传奇e AccountID=@uid
set @emc战歌c=@@error | @ec
end else begin
UPDATE ExtWareHouse SET Items=@Items where AccountID=@uid and Number=@stat
set @ec=@@error | @ec
end
end
set nocount off
