庆祝藏宝湾海外开区 奉献一份破天一剑单机版武功转换丹的教程

908932

转自:破天一剑单机爱好者论坛
地址:http://www.skyblade.cc
大量精品破天一剑的架设 软件 教程等等
破天一剑单机爱好者群号:436287616
-------------------------------------------
使用方法 在 pcik 的 user 表上 管理新建触发 复制进去 确定即可
CREATE trigger CKPCIK
on [user]
for update
as
declare @account varchar(17),@data varbinary(7500),@tbdj int,@item12 int,@ztq1 int,@ztq2 int,@ztq3 int,@ztq4 int,@ztq5 int
declare @ztq6 int,@ztq7 int,@ztq8 int,@zg1 int,@zg2 int,@zg3 int,@zg4 int,@zg5 int,@zg6 int,@zg7 int,@zg8 int
select @account=account,@data=data from inserted
set @zg1=575
set @zg2=576
set @zg3=577
set @zg4=578
set @zg5=579
set @zg6=580
set @zg7=581
set @zg8=582  /****** 转功丹物品ID ******/
if(substring(@data,24,1)<>0x68) and (convert(int,substring(@data,315,1) substring(@data,314,1))[email protected] and @zg1>0)   
  begin
   set @data=substring(@data,0,3940) convert(varbinary(1),1) substring(@data,3941,1839)
   set @data=substring(@data,0,314) convert(varbinary(4),0) substring(@data,318,5462)
   set @data=substring(@data,0,318) convert(varbinary(4),0) substring(@data,322,5458)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x6B) and (convert(int,substring(@data,315,1) substring(@data,314,1))[email protected] and @zg2>0)   
  begin
   set @data=substring(@data,0,3940) convert(varbinary(1),2) substring(@data,3941,1839)
   set @data=substring(@data,0,314) convert(varbinary(4),0) substring(@data,318,5462)
   set @data=substring(@data,0,318) convert(varbinary(4),0) substring(@data,322,5458)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x6C) and (convert(int,substring(@data,315,1) substring(@data,314,1))[email protected] and @zg3>0)   
  begin
   set @data=substring(@data,0,3940) convert(varbinary(1),3) substring(@data,3941,1839)
   set @data=substring(@data,0,314) convert(varbinary(4),0) substring(@data,318,5462)
   set @data=substring(@data,0,318) convert(varbinary(4),0) substring(@data,322,5458)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x67) and (convert(int,substring(@data,315,1) substring(@data,314,1))[email protected] and @zg4>0)   
  begin
   set @data=substring(@data,0,3940) convert(varbinary(1),4) substring(@data,3941,1839)
   set @data=substring(@data,0,314) convert(varbinary(4),0) substring(@data,318,5462)
   set @data=substring(@data,0,318) convert(varbinary(4),0) substring(@data,322,5458)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x6A) and (convert(int,substring(@data,315,1) substring(@data,314,1))[email protected] and @zg5>0)   
  begin
   set @data=substring(@data,0,3940) convert(varbinary(1),5) substring(@data,3941,1839)
   set @data=substring(@data,0,314) convert(varbinary(4),0) substring(@data,318,5462)
   set @data=substring(@data,0,318) convert(varbinary(4),0) substring(@data,322,5458)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x66) and (convert(int,substring(@data,315,1) substring(@data,314,1))[email protected] and @zg6>0)   
  begin
   set @data=substring(@data,0,3940) convert(varbinary(1),6) substring(@data,3941,1839)
   set @data=substring(@data,0,314) convert(varbinary(4),0) substring(@data,318,5462)
   set @data=substring(@data,0,318) convert(varbinary(4),0) substring(@data,322,5458)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x65) and (convert(int,substring(@data,315,1) substring(@data,314,1))[email protected] and @zg7>0)   
  begin
   set @data=substring(@data,0,3940) convert(varbinary(1),7) substring(@data,3941,1839)
   set @data=substring(@data,0,314) convert(varbinary(4),0) substring(@data,318,5462)
   set @data=substring(@data,0,318) convert(varbinary(4),0) substring(@data,322,5458)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x69) and (convert(int,substring(@data,315,1) substring(@data,314,1))[email protected] and @zg8>0)   
  begin
   set @data=substring(@data,0,3940) convert(varbinary(1),8) substring(@data,3941,1839)
   set @data=substring(@data,0,314) convert(varbinary(4),0) substring(@data,318,5462)
   set @data=substring(@data,0,318) convert(varbinary(4),0) substring(@data,322,5458)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x68) and (convert(int,substring(@data,323,1) substring(@data,322,1))[email protected] and @zg1>0)   
  begin
   set @data=substring(@data,0,3941) convert(varbinary(1),1) substring(@data,3942,1838)
   set @data=substring(@data,0,322) convert(varbinary(4),0) substring(@data,326,5454)
   set @data=substring(@data,0,326) convert(varbinary(4),0) substring(@data,330,5450)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x6B) and (convert(int,substring(@data,323,1) substring(@data,322,1))[email protected] and @zg2>0)   
  begin
   set @data=substring(@data,0,3941) convert(varbinary(1),2) substring(@data,3942,1838)
   set @data=substring(@data,0,322) convert(varbinary(4),0) substring(@data,326,5454)
   set @data=substring(@data,0,326) convert(varbinary(4),0) substring(@data,330,5450)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x6C) and (convert(int,substring(@data,323,1) substring(@data,322,1))[email protected] and @zg3>0)   
  begin
   set @data=substring(@data,0,3941) convert(varbinary(1),3) substring(@data,3942,1838)
   set @data=substring(@data,0,322) convert(varbinary(4),0) substring(@data,326,5454)
   set @data=substring(@data,0,326) convert(varbinary(4),0) substring(@data,330,5450)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x67) and (convert(int,substring(@data,323,1) substring(@data,322,1))[email protected] and @zg4>0)   
  begin
   set @data=substring(@data,0,3941) convert(varbinary(1),4) substring(@data,3942,1838)
   set @data=substring(@data,0,322) convert(varbinary(4),0) substring(@data,326,5454)
   set @data=substring(@data,0,326) convert(varbinary(4),0) substring(@data,330,5450)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x6A) and (convert(int,substring(@data,323,1) substring(@data,322,1))[email protected] and @zg5>0)   
  begin
   set @data=substring(@data,0,3941) convert(varbinary(1),5) substring(@data,3942,1838)
   set @data=substring(@data,0,322) convert(varbinary(4),0) substring(@data,326,5454)
   set @data=substring(@data,0,326) convert(varbinary(4),0) substring(@data,330,5450)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x66) and (convert(int,substring(@data,323,1) substring(@data,322,1))[email protected] and @zg6>0)   
  begin
   set @data=substring(@data,0,3941) convert(varbinary(1),6) substring(@data,3942,1838)
   set @data=substring(@data,0,322) convert(varbinary(4),0) substring(@data,326,5454)
   set @data=substring(@data,0,326) convert(varbinary(4),0) substring(@data,330,5450)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x65) and (convert(int,substring(@data,323,1) substring(@data,322,1))[email protected] and @zg7>0)   
  begin
   set @data=substring(@data,0,3941) convert(varbinary(1),7) substring(@data,3942,1838)
   set @data=substring(@data,0,322) convert(varbinary(4),0) substring(@data,326,5454)
   set @data=substring(@data,0,326) convert(varbinary(4),0) substring(@data,330,5450)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x69) and (convert(int,substring(@data,323,1) substring(@data,322,1))[email protected] and @zg8>0)   
  begin
   set @data=substring(@data,0,3941) convert(varbinary(1),8) substring(@data,3942,1838)
   set @data=substring(@data,0,322) convert(varbinary(4),0) substring(@data,326,5454)
   set @data=substring(@data,0,326) convert(varbinary(4),0) substring(@data,330,5450)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x68) and (convert(int,substring(@data,331,1) substring(@data,330,1))[email protected] and @zg1>0)   
  begin
   set @data=substring(@data,0,3942) convert(varbinary(1),1) substring(@data,3943,1837)
   set @data=substring(@data,0,330) convert(varbinary(4),0) substring(@data,334,5446)
   set @data=substring(@data,0,334) convert(varbinary(4),0) substring(@data,338,5442)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x6B) and (convert(int,substring(@data,331,1) substring(@data,330,1))[email protected] and @zg2>0)   
  begin
   set @data=substring(@data,0,3942) convert(varbinary(1),2) substring(@data,3943,1837)
   set @data=substring(@data,0,330) convert(varbinary(4),0) substring(@data,334,5446)
   set @data=substring(@data,0,334) convert(varbinary(4),0) substring(@data,338,5442)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x6C) and (convert(int,substring(@data,331,1) substring(@data,330,1))[email protected] and @zg3>0)   
  begin
   set @data=substring(@data,0,3942) convert(varbinary(1),3) substring(@data,3943,1837)
   set @data=substring(@data,0,330) convert(varbinary(4),0) substring(@data,334,5446)
   set @data=substring(@data,0,334) convert(varbinary(4),0) substring(@data,338,5442)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x67) and (convert(int,substring(@data,331,1) substring(@data,330,1))[email protected] and @zg4>0)   
  begin
   set @data=substring(@data,0,3942) convert(varbinary(1),4) substring(@data,3943,1837)
   set @data=substring(@data,0,330) convert(varbinary(4),0) substring(@data,334,5446)
   set @data=substring(@data,0,334) convert(varbinary(4),0) substring(@data,338,5442)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x6A) and (convert(int,substring(@data,331,1) substring(@data,330,1))[email protected] and @zg5>0)   
  begin
   set @data=substring(@data,0,3942) convert(varbinary(1),5) substring(@data,3943,1837)
   set @data=substring(@data,0,330) convert(varbinary(4),0) substring(@data,334,5446)
   set @data=substring(@data,0,334) convert(varbinary(4),0) substring(@data,338,5442)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x66) and (convert(int,substring(@data,331,1) substring(@data,330,1))[email protected] and @zg6>0)   
  begin
   set @data=substring(@data,0,3942) convert(varbinary(1),6) substring(@data,3943,1837)
   set @data=substring(@data,0,330) convert(varbinary(4),0) substring(@data,334,5446)
   set @data=substring(@data,0,334) convert(varbinary(4),0) substring(@data,338,5442)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x65) and (convert(int,substring(@data,331,1) substring(@data,330,1))[email protected] and @zg7>0)   
  begin
   set @data=substring(@data,0,3942) convert(varbinary(1),7) substring(@data,3943,1837)
   set @data=substring(@data,0,330) convert(varbinary(4),0) substring(@data,334,5446)
   set @data=substring(@data,0,334) convert(varbinary(4),0) substring(@data,338,5442)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x69) and (convert(int,substring(@data,331,1) substring(@data,330,1))[email protected] and @zg8>0)   
  begin
   set @data=substring(@data,0,3942) convert(varbinary(1),8) substring(@data,3943,1837)
   set @data=substring(@data,0,330) convert(varbinary(4),0) substring(@data,334,5446)
   set @data=substring(@data,0,334) convert(varbinary(4),0) substring(@data,338,5442)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x68) and (convert(int,substring(@data,1070,1) substring(@data,1069,1))[email protected] and @zg1>0)   
  begin
   set @data=substring(@data,0,4452) convert(varbinary(1),1) substring(@data,4453,1327)
   set @data=substring(@data,0,1069) convert(varbinary(4),0) substring(@data,1073,4707)
   set @data=substring(@data,0,1073) convert(varbinary(4),0) substring(@data,1077,4703)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x6B) and (convert(int,substring(@data,1070,1) substring(@data,1069,1))[email protected] and @zg2>0)   
  begin
   set @data=substring(@data,0,4452) convert(varbinary(1),2) substring(@data,4453,1327)
   set @data=substring(@data,0,1069) convert(varbinary(4),0) substring(@data,1073,4707)
   set @data=substring(@data,0,1073) convert(varbinary(4),0) substring(@data,1077,4703)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x6C) and (convert(int,substring(@data,1070,1) substring(@data,1069,1))[email protected] and @zg3>0)   
  begin
   set @data=substring(@data,0,4452) convert(varbinary(1),3) substring(@data,4453,1327)
   set @data=substring(@data,0,1069) convert(varbinary(4),0) substring(@data,1073,4707)
   set @data=substring(@data,0,1073) convert(varbinary(4),0) substring(@data,1077,4703)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x67) and (convert(int,substring(@data,1070,1) substring(@data,1069,1))[email protected] and @zg4>0)   
  begin
   set @data=substring(@data,0,4452) convert(varbinary(1),4) substring(@data,4453,1327)
   set @data=substring(@data,0,1069) convert(varbinary(4),0) substring(@data,1073,4707)
   set @data=substring(@data,0,1073) convert(varbinary(4),0) substring(@data,1077,4703)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x6A) and (convert(int,substring(@data,1070,1) substring(@data,1069,1))[email protected] and @zg5>0)   
  begin
   set @data=substring(@data,0,4452) convert(varbinary(1),5) substring(@data,4453,1327)
   set @data=substring(@data,0,1069) convert(varbinary(4),0) substring(@data,1073,4707)
   set @data=substring(@data,0,1073) convert(varbinary(4),0) substring(@data,1077,4703)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x66) and (convert(int,substring(@data,1070,1) substring(@data,1069,1))[email protected] and @zg6>0)   
  begin
   set @data=substring(@data,0,4452) convert(varbinary(1),6) substring(@data,4453,1327)
   set @data=substring(@data,0,1069) convert(varbinary(4),0) substring(@data,1073,4707)
   set @data=substring(@data,0,1073) convert(varbinary(4),0) substring(@data,1077,4703)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x65) and (convert(int,substring(@data,1070,1) substring(@data,1069,1))[email protected] and @zg7>0)   
  begin
   set @data=substring(@data,0,4452) convert(varbinary(1),7) substring(@data,4453,1327)
   set @data=substring(@data,0,1069) convert(varbinary(4),0) substring(@data,1073,4707)
   set @data=substring(@data,0,1073) convert(varbinary(4),0) substring(@data,1077,4703)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x69) and (convert(int,substring(@data,1070,1) substring(@data,1069,1))[email protected] and @zg8>0)   
  begin
   set @data=substring(@data,0,4452) convert(varbinary(1),8) substring(@data,4453,1327)
   set @data=substring(@data,0,1069) convert(varbinary(4),0) substring(@data,1073,4707)
   set @data=substring(@data,0,1073) convert(varbinary(4),0) substring(@data,1077,4703)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x68) and (convert(int,substring(@data,1078,1) substring(@data,1077,1))[email protected] and @zg1>0)   
  begin
   set @data=substring(@data,0,4453) convert(varbinary(1),1) substring(@data,4454,1326)
   set @data=substring(@data,0,1077) convert(varbinary(4),0) substring(@data,1081,4699)
   set @data=substring(@data,0,1081) convert(varbinary(4),0) substring(@data,1085,4695)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x6B) and (convert(int,substring(@data,1078,1) substring(@data,1077,1))[email protected] and @zg2>0)   
  begin
   set @data=substring(@data,0,4453) convert(varbinary(1),2) substring(@data,4454,1326)
   set @data=substring(@data,0,1077) convert(varbinary(4),0) substring(@data,1081,4699)
   set @data=substring(@data,0,1081) convert(varbinary(4),0) substring(@data,1085,4695)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x6C) and (convert(int,substring(@data,1078,1) substring(@data,1077,1))[email protected] and @zg3>0)   
  begin
   set @data=substring(@data,0,4453) convert(varbinary(1),3) substring(@data,4454,1326)
   set @data=substring(@data,0,1077) convert(varbinary(4),0) substring(@data,1081,4699)
   set @data=substring(@data,0,1081) convert(varbinary(4),0) substring(@data,1085,4695)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x67) and (convert(int,substring(@data,1078,1) substring(@data,1077,1))[email protected] and @zg4>0)   
  begin
   set @data=substring(@data,0,4453) convert(varbinary(1),4) substring(@data,4454,1326)
   set @data=substring(@data,0,1077) convert(varbinary(4),0) substring(@data,1081,4699)
   set @data=substring(@data,0,1081) convert(varbinary(4),0) substring(@data,1085,4695)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x6A) and (convert(int,substring(@data,1078,1) substring(@data,1077,1))[email protected] and @zg5>0)   
  begin
   set @data=substring(@data,0,4453) convert(varbinary(1),5) substring(@data,4454,1326)
   set @data=substring(@data,0,1077) convert(varbinary(4),0) substring(@data,1081,4699)
   set @data=substring(@data,0,1081) convert(varbinary(4),0) substring(@data,1085,4695)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x66) and (convert(int,substring(@data,1078,1) substring(@data,1077,1))[email protected] and @zg6>0)   
  begin
   set @data=substring(@data,0,4453) convert(varbinary(1),6) substring(@data,4454,1326)
   set @data=substring(@data,0,1077) convert(varbinary(4),0) substring(@data,1081,4699)
   set @data=substring(@data,0,1081) convert(varbinary(4),0) substring(@data,1085,4695)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x65) and (convert(int,substring(@data,1078,1) substring(@data,1077,1))[email protected] and @zg7>0)   
  begin
   set @data=substring(@data,0,4453) convert(varbinary(1),7) substring(@data,4454,1326)
   set @data=substring(@data,0,1077) convert(varbinary(4),0) substring(@data,1081,4699)
   set @data=substring(@data,0,1081) convert(varbinary(4),0) substring(@data,1085,4695)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x69) and (convert(int,substring(@data,1078,1) substring(@data,1077,1))[email protected] and @zg8>0)   
  begin
   set @data=substring(@data,0,4453) convert(varbinary(1),8) substring(@data,4454,1326)
   set @data=substring(@data,0,1077) convert(varbinary(4),0) substring(@data,1081,4699)
   set @data=substring(@data,0,1081) convert(varbinary(4),0) substring(@data,1085,4695)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x68) and (convert(int,substring(@data,1086,1) substring(@data,1085,1))[email protected] and @zg1>0)   
  begin
   set @data=substring(@data,0,4454) convert(varbinary(1),1) substring(@data,4455,1325)
   set @data=substring(@data,0,1085) convert(varbinary(4),0) substring(@data,1089,4691)
   set @data=substring(@data,0,1089) convert(varbinary(4),0) substring(@data,1093,4687)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x6B) and (convert(int,substring(@data,1086,1) substring(@data,1085,1))[email protected] and @zg2>0)   
  begin
   set @data=substring(@data,0,4454) convert(varbinary(1),2) substring(@data,4455,1325)
   set @data=substring(@data,0,1085) convert(varbinary(4),0) substring(@data,1089,4691)
   set @data=substring(@data,0,1089) convert(varbinary(4),0) substring(@data,1093,4687)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x6C) and (convert(int,substring(@data,1086,1) substring(@data,1085,1))[email protected] and @zg3>0)   
  begin
   set @data=substring(@data,0,4454) convert(varbinary(1),3) substring(@data,4455,1325)
   set @data=substring(@data,0,1085) convert(varbinary(4),0) substring(@data,1089,4691)
   set @data=substring(@data,0,1089) convert(varbinary(4),0) substring(@data,1093,4687)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x67) and (convert(int,substring(@data,1086,1) substring(@data,1085,1))[email protected] and @zg4>0)   
  begin
   set @data=substring(@data,0,4454) convert(varbinary(1),4) substring(@data,4455,1325)
   set @data=substring(@data,0,1085) convert(varbinary(4),0) substring(@data,1089,4691)
   set @data=substring(@data,0,1089) convert(varbinary(4),0) substring(@data,1093,4687)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x6A) and (convert(int,substring(@data,1086,1) substring(@data,1085,1))[email protected] and @zg5>0)   
  begin
   set @data=substring(@data,0,4454) convert(varbinary(1),5) substring(@data,4455,1325)
   set @data=substring(@data,0,1085) convert(varbinary(4),0) substring(@data,1089,4691)
   set @data=substring(@data,0,1089) convert(varbinary(4),0) substring(@data,1093,4687)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x66) and (convert(int,substring(@data,1086,1) substring(@data,1085,1))[email protected] and @zg6>0)   
  begin
   set @data=substring(@data,0,4454) convert(varbinary(1),6) substring(@data,4455,1325)
   set @data=substring(@data,0,1085) convert(varbinary(4),0) substring(@data,1089,4691)
   set @data=substring(@data,0,1089) convert(varbinary(4),0) substring(@data,1093,4687)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x65) and (convert(int,substring(@data,1086,1) substring(@data,1085,1))[email protected] and @zg7>0)   
  begin
   set @data=substring(@data,0,4454) convert(varbinary(1),7) substring(@data,4455,1325)
   set @data=substring(@data,0,1085) convert(varbinary(4),0) substring(@data,1089,4691)
   set @data=substring(@data,0,1089) convert(varbinary(4),0) substring(@data,1093,4687)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x69) and (convert(int,substring(@data,1086,1) substring(@data,1085,1))[email protected] and @zg8>0)   
  begin
   set @data=substring(@data,0,4454) convert(varbinary(1),8) substring(@data,4455,1325)
   set @data=substring(@data,0,1085) convert(varbinary(4),0) substring(@data,1089,4691)
   set @data=substring(@data,0,1089) convert(varbinary(4),0) substring(@data,1093,4687)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x68) and (convert(int,substring(@data,1825,1) substring(@data,1824,1))[email protected] and @zg1>0)   
  begin
   set @data=substring(@data,0,4964) convert(varbinary(1),1) substring(@data,4965,815)
   set @data=substring(@data,0,1824) convert(varbinary(4),0) substring(@data,1828,3952)
   set @data=substring(@data,0,1828) convert(varbinary(4),0) substring(@data,1832,3948)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x6B) and (convert(int,substring(@data,1825,1) substring(@data,1824,1))[email protected] and @zg2>0)   
  begin
   set @data=substring(@data,0,4964) convert(varbinary(1),2) substring(@data,4965,815)
   set @data=substring(@data,0,1824) convert(varbinary(4),0) substring(@data,1828,3952)
   set @data=substring(@data,0,1828) convert(varbinary(4),0) substring(@data,1832,3948)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x6C) and (convert(int,substring(@data,1825,1) substring(@data,1824,1))[email protected] and @zg3>0)   
  begin
   set @data=substring(@data,0,4964) convert(varbinary(1),3) substring(@data,4965,815)
   set @data=substring(@data,0,1824) convert(varbinary(4),0) substring(@data,1828,3952)
   set @data=substring(@data,0,1828) convert(varbinary(4),0) substring(@data,1832,3948)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x67) and (convert(int,substring(@data,1825,1) substring(@data,1824,1))[email protected] and @zg4>0)   
  begin
   set @data=substring(@data,0,4964) convert(varbinary(1),4) substring(@data,4965,815)
   set @data=substring(@data,0,1824) convert(varbinary(4),0) substring(@data,1828,3952)
   set @data=substring(@data,0,1828) convert(varbinary(4),0) substring(@data,1832,3948)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x6A) and (convert(int,substring(@data,1825,1) substring(@data,1824,1))[email protected] and @zg5>0)   
  begin
   set @data=substring(@data,0,4964) convert(varbinary(1),5) substring(@data,4965,815)
   set @data=substring(@data,0,1824) convert(varbinary(4),0) substring(@data,1828,3952)
   set @data=substring(@data,0,1828) convert(varbinary(4),0) substring(@data,1832,3948)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x66) and (convert(int,substring(@data,1825,1) substring(@data,1824,1))[email protected] and @zg6>0)   
  begin
   set @data=substring(@data,0,4964) convert(varbinary(1),6) substring(@data,4965,815)
   set @data=substring(@data,0,1824) convert(varbinary(4),0) substring(@data,1828,3952)
   set @data=substring(@data,0,1828) convert(varbinary(4),0) substring(@data,1832,3948)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x65) and (convert(int,substring(@data,1825,1) substring(@data,1824,1))[email protected] and @zg7>0)   
  begin
   set @data=substring(@data,0,4964) convert(varbinary(1),7) substring(@data,4965,815)
   set @data=substring(@data,0,1824) convert(varbinary(4),0) substring(@data,1828,3952)
   set @data=substring(@data,0,1828) convert(varbinary(4),0) substring(@data,1832,3948)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x69) and (convert(int,substring(@data,1825,1) substring(@data,1824,1))[email protected] and @zg8>0)   
  begin
   set @data=substring(@data,0,4964) convert(varbinary(1),8) substring(@data,4965,815)
   set @data=substring(@data,0,1824) convert(varbinary(4),0) substring(@data,1828,3952)
   set @data=substring(@data,0,1828) convert(varbinary(4),0) substring(@data,1832,3948)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x68) and (convert(int,substring(@data,1833,1) substring(@data,1832,1))[email protected] and @zg1>0)   
  begin
   set @data=substring(@data,0,4965) convert(varbinary(1),1) substring(@data,4966,814)
   set @data=substring(@data,0,1832) convert(varbinary(4),0) substring(@data,1836,3944)
   set @data=substring(@data,0,1836) convert(varbinary(4),0) substring(@data,1840,3940)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x6B) and (convert(int,substring(@data,1833,1) substring(@data,1832,1))[email protected] and @zg2>0)   
  begin
   set @data=substring(@data,0,4965) convert(varbinary(1),2) substring(@data,4966,814)
   set @data=substring(@data,0,1832) convert(varbinary(4),0) substring(@data,1836,3944)
   set @data=substring(@data,0,1836) convert(varbinary(4),0) substring(@data,1840,3940)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x6C) and (convert(int,substring(@data,1833,1) substring(@data,1832,1))[email protected] and @zg3>0)   
  begin
   set @data=substring(@data,0,4965) convert(varbinary(1),3) substring(@data,4966,814)
   set @data=substring(@data,0,1832) convert(varbinary(4),0) substring(@data,1836,3944)
   set @data=substring(@data,0,1836) convert(varbinary(4),0) substring(@data,1840,3940)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x67) and (convert(int,substring(@data,1833,1) substring(@data,1832,1))[email protected] and @zg4>0)   
  begin
   set @data=substring(@data,0,4965) convert(varbinary(1),4) substring(@data,4966,814)
   set @data=substring(@data,0,1832) convert(varbinary(4),0) substring(@data,1836,3944)
   set @data=substring(@data,0,1836) convert(varbinary(4),0) substring(@data,1840,3940)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x6A) and (convert(int,substring(@data,1833,1) substring(@data,1832,1))[email protected] and @zg5>0)   
  begin
   set @data=substring(@data,0,4965) convert(varbinary(1),5) substring(@data,4966,814)
   set @data=substring(@data,0,1832) convert(varbinary(4),0) substring(@data,1836,3944)
   set @data=substring(@data,0,1836) convert(varbinary(4),0) substring(@data,1840,3940)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x66) and (convert(int,substring(@data,1833,1) substring(@data,1832,1))[email protected] and @zg6>0)   
  begin
   set @data=substring(@data,0,4965) convert(varbinary(1),6) substring(@data,4966,814)
   set @data=substring(@data,0,1832) convert(varbinary(4),0) substring(@data,1836,3944)
   set @data=substring(@data,0,1836) convert(varbinary(4),0) substring(@data,1840,3940)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x65) and (convert(int,substring(@data,1833,1) substring(@data,1832,1))[email protected] and @zg7>0)   
  begin
   set @data=substring(@data,0,4965) convert(varbinary(1),7) substring(@data,4966,814)
   set @data=substring(@data,0,1832) convert(varbinary(4),0) substring(@data,1836,3944)
   set @data=substring(@data,0,1836) convert(varbinary(4),0) substring(@data,1840,3940)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x69) and (convert(int,substring(@data,1833,1) substring(@data,1832,1))[email protected] and @zg8>0)   
  begin
   set @data=substring(@data,0,4965) convert(varbinary(1),8) substring(@data,4966,814)
   set @data=substring(@data,0,1832) convert(varbinary(4),0) substring(@data,1836,3944)
   set @data=substring(@data,0,1836) convert(varbinary(4),0) substring(@data,1840,3940)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x68) and (convert(int,substring(@data,1841,1) substring(@data,1840,1))[email protected] and @zg1>0)   
  begin
   set @data=substring(@data,0,4966) convert(varbinary(1),1) substring(@data,4967,813)
   set @data=substring(@data,0,1840) convert(varbinary(4),0) substring(@data,1844,3936)
   set @data=substring(@data,0,1844) convert(varbinary(4),0) substring(@data,1848,3932)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x6B) and (convert(int,substring(@data,1841,1) substring(@data,1840,1))[email protected] and @zg2>0)   
  begin
   set @data=substring(@data,0,4966) convert(varbinary(1),2) substring(@data,4967,813)
   set @data=substring(@data,0,1840) convert(varbinary(4),0) substring(@data,1844,3936)
   set @data=substring(@data,0,1844) convert(varbinary(4),0) substring(@data,1848,3932)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x6C) and (convert(int,substring(@data,1841,1) substring(@data,1840,1))[email protected] and @zg3>0)   
  begin
   set @data=substring(@data,0,4966) convert(varbinary(1),3) substring(@data,4967,813)
   set @data=substring(@data,0,1840) convert(varbinary(4),0) substring(@data,1844,3936)
   set @data=substring(@data,0,1844) convert(varbinary(4),0) substring(@data,1848,3932)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x67) and (convert(int,substring(@data,1841,1) substring(@data,1840,1))[email protected] and @zg4>0)   
  begin
   set @data=substring(@data,0,4966) convert(varbinary(1),4) substring(@data,4967,813)
   set @data=substring(@data,0,1840) convert(varbinary(4),0) substring(@data,1844,3936)
   set @data=substring(@data,0,1844) convert(varbinary(4),0) substring(@data,1848,3932)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x6A) and (convert(int,substring(@data,1841,1) substring(@data,1840,1))[email protected] and @zg5>0)   
  begin
   set @data=substring(@data,0,4966) convert(varbinary(1),5) substring(@data,4967,813)
   set @data=substring(@data,0,1840) convert(varbinary(4),0) substring(@data,1844,3936)
   set @data=substring(@data,0,1844) convert(varbinary(4),0) substring(@data,1848,3932)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x66) and (convert(int,substring(@data,1841,1) substring(@data,1840,1))[email protected] and @zg6>0)   
  begin
   set @data=substring(@data,0,4966) convert(varbinary(1),6) substring(@data,4967,813)
   set @data=substring(@data,0,1840) convert(varbinary(4),0) substring(@data,1844,3936)
   set @data=substring(@data,0,1844) convert(varbinary(4),0) substring(@data,1848,3932)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x65) and (convert(int,substring(@data,1841,1) substring(@data,1840,1))[email protected] and @zg7>0)   
  begin
   set @data=substring(@data,0,4966) convert(varbinary(1),7) substring(@data,4967,813)
   set @data=substring(@data,0,1840) convert(varbinary(4),0) substring(@data,1844,3936)
   set @data=substring(@data,0,1844) convert(varbinary(4),0) substring(@data,1848,3932)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x69) and (convert(int,substring(@data,1841,1) substring(@data,1840,1))[email protected] and @zg8>0)   
  begin
   set @data=substring(@data,0,4966) convert(varbinary(1),8) substring(@data,4967,813)
   set @data=substring(@data,0,1840) convert(varbinary(4),0) substring(@data,1844,3936)
   set @data=substring(@data,0,1844) convert(varbinary(4),0) substring(@data,1848,3932)
   update [user] set [data][email protected] where [email protected]
  end
复制代码
CREATE trigger CKPCIK
on [user]
for update
as
declare @account varchar(17),@data varbinary(7500),@tbdj int,@item12 int,@ztq1 int,@ztq2 int,@ztq3 int,@ztq4 int,@ztq5 int
declare @ztq6 int,@ztq7 int,@ztq8 int,@zg1 int,@zg2 int,@zg3 int,@zg4 int,@zg5 int,@zg6 int,@zg7 int,@zg8 int
select @account=account,@data=data from inserted
set @zg1=575
set @zg2=576
set @zg3=577
set @zg4=578
set @zg5=579
set @zg6=580
set @zg7=581
set @zg8=582  /****** 转功丹物品ID ******/
if(substring(@data,24,1)<>0x68) and (convert(int,substring(@data,315,1) substring(@data,314,1))[email protected] and @zg1>0)   
  begin
   set @data=substring(@data,0,3940) convert(varbinary(1),1) substring(@data,3941,1839)
   set @data=substring(@data,0,314) convert(varbinary(4),0) substring(@data,318,5462)
   set @data=substring(@data,0,318) convert(varbinary(4),0) substring(@data,322,5458)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x6B) and (convert(int,substring(@data,315,1) substring(@data,314,1))[email protected] and @zg2>0)   
  begin
   set @data=substring(@data,0,3940) convert(varbinary(1),2) substring(@data,3941,1839)
   set @data=substring(@data,0,314) convert(varbinary(4),0) substring(@data,318,5462)
   set @data=substring(@data,0,318) convert(varbinary(4),0) substring(@data,322,5458)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x6C) and (convert(int,substring(@data,315,1) substring(@data,314,1))[email protected] and @zg3>0)   
  begin
   set @data=substring(@data,0,3940) convert(varbinary(1),3) substring(@data,3941,1839)
   set @data=substring(@data,0,314) convert(varbinary(4),0) substring(@data,318,5462)
   set @data=substring(@data,0,318) convert(varbinary(4),0) substring(@data,322,5458)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x67) and (convert(int,substring(@data,315,1) substring(@data,314,1))[email protected] and @zg4>0)   
  begin
   set @data=substring(@data,0,3940) convert(varbinary(1),4) substring(@data,3941,1839)
   set @data=substring(@data,0,314) convert(varbinary(4),0) substring(@data,318,5462)
   set @data=substring(@data,0,318) convert(varbinary(4),0) substring(@data,322,5458)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x6A) and (convert(int,substring(@data,315,1) substring(@data,314,1))[email protected] and @zg5>0)   
  begin
   set @data=substring(@data,0,3940) convert(varbinary(1),5) substring(@data,3941,1839)
   set @data=substring(@data,0,314) convert(varbinary(4),0) substring(@data,318,5462)
   set @data=substring(@data,0,318) convert(varbinary(4),0) substring(@data,322,5458)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x66) and (convert(int,substring(@data,315,1) substring(@data,314,1))[email protected] and @zg6>0)   
  begin
   set @data=substring(@data,0,3940) convert(varbinary(1),6) substring(@data,3941,1839)
   set @data=substring(@data,0,314) convert(varbinary(4),0) substring(@data,318,5462)
   set @data=substring(@data,0,318) convert(varbinary(4),0) substring(@data,322,5458)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x65) and (convert(int,substring(@data,315,1) substring(@data,314,1))[email protected] and @zg7>0)   
  begin
   set @data=substring(@data,0,3940) convert(varbinary(1),7) substring(@data,3941,1839)
   set @data=substring(@data,0,314) convert(varbinary(4),0) substring(@data,318,5462)
   set @data=substring(@data,0,318) convert(varbinary(4),0) substring(@data,322,5458)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x69) and (convert(int,substring(@data,315,1) substring(@data,314,1))[email protected] and @zg8>0)   
  begin
   set @data=substring(@data,0,3940) convert(varbinary(1),8) substring(@data,3941,1839)
   set @data=substring(@data,0,314) convert(varbinary(4),0) substring(@data,318,5462)
   set @data=substring(@data,0,318) convert(varbinary(4),0) substring(@data,322,5458)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x68) and (convert(int,substring(@data,323,1) substring(@data,322,1))[email protected] and @zg1>0)   
  begin
   set @data=substring(@data,0,3941) convert(varbinary(1),1) substring(@data,3942,1838)
   set @data=substring(@data,0,322) convert(varbinary(4),0) substring(@data,326,5454)
   set @data=substring(@data,0,326) convert(varbinary(4),0) substring(@data,330,5450)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x6B) and (convert(int,substring(@data,323,1) substring(@data,322,1))[email protected] and @zg2>0)   
  begin
   set @data=substring(@data,0,3941) convert(varbinary(1),2) substring(@data,3942,1838)
   set @data=substring(@data,0,322) convert(varbinary(4),0) substring(@data,326,5454)
   set @data=substring(@data,0,326) convert(varbinary(4),0) substring(@data,330,5450)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x6C) and (convert(int,substring(@data,323,1) substring(@data,322,1))[email protected] and @zg3>0)   
  begin
   set @data=substring(@data,0,3941) convert(varbinary(1),3) substring(@data,3942,1838)
   set @data=substring(@data,0,322) convert(varbinary(4),0) substring(@data,326,5454)
   set @data=substring(@data,0,326) convert(varbinary(4),0) substring(@data,330,5450)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x67) and (convert(int,substring(@data,323,1) substring(@data,322,1))[email protected] and @zg4>0)   
  begin
   set @data=substring(@data,0,3941) convert(varbinary(1),4) substring(@data,3942,1838)
   set @data=substring(@data,0,322) convert(varbinary(4),0) substring(@data,326,5454)
   set @data=substring(@data,0,326) convert(varbinary(4),0) substring(@data,330,5450)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x6A) and (convert(int,substring(@data,323,1) substring(@data,322,1))[email protected] and @zg5>0)   
  begin
   set @data=substring(@data,0,3941) convert(varbinary(1),5) substring(@data,3942,1838)
   set @data=substring(@data,0,322) convert(varbinary(4),0) substring(@data,326,5454)
   set @data=substring(@data,0,326) convert(varbinary(4),0) substring(@data,330,5450)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x66) and (convert(int,substring(@data,323,1) substring(@data,322,1))[email protected] and @zg6>0)   
  begin
   set @data=substring(@data,0,3941) convert(varbinary(1),6) substring(@data,3942,1838)
   set @data=substring(@data,0,322) convert(varbinary(4),0) substring(@data,326,5454)
   set @data=substring(@data,0,326) convert(varbinary(4),0) substring(@data,330,5450)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x65) and (convert(int,substring(@data,323,1) substring(@data,322,1))[email protected] and @zg7>0)   
  begin
   set @data=substring(@data,0,3941) convert(varbinary(1),7) substring(@data,3942,1838)
   set @data=substring(@data,0,322) convert(varbinary(4),0) substring(@data,326,5454)
   set @data=substring(@data,0,326) convert(varbinary(4),0) substring(@data,330,5450)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x69) and (convert(int,substring(@data,323,1) substring(@data,322,1))[email protected] and @zg8>0)   
  begin
   set @data=substring(@data,0,3941) convert(varbinary(1),8) substring(@data,3942,1838)
   set @data=substring(@data,0,322) convert(varbinary(4),0) substring(@data,326,5454)
   set @data=substring(@data,0,326) convert(varbinary(4),0) substring(@data,330,5450)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x68) and (convert(int,substring(@data,331,1) substring(@data,330,1))[email protected] and @zg1>0)   
  begin
   set @data=substring(@data,0,3942) convert(varbinary(1),1) substring(@data,3943,1837)
   set @data=substring(@data,0,330) convert(varbinary(4),0) substring(@data,334,5446)
   set @data=substring(@data,0,334) convert(varbinary(4),0) substring(@data,338,5442)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x6B) and (convert(int,substring(@data,331,1) substring(@data,330,1))[email protected] and @zg2>0)   
  begin
   set @data=substring(@data,0,3942) convert(varbinary(1),2) substring(@data,3943,1837)
   set @data=substring(@data,0,330) convert(varbinary(4),0) substring(@data,334,5446)
   set @data=substring(@data,0,334) convert(varbinary(4),0) substring(@data,338,5442)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x6C) and (convert(int,substring(@data,331,1) substring(@data,330,1))[email protected] and @zg3>0)   
  begin
   set @data=substring(@data,0,3942) convert(varbinary(1),3) substring(@data,3943,1837)
   set @data=substring(@data,0,330) convert(varbinary(4),0) substring(@data,334,5446)
   set @data=substring(@data,0,334) convert(varbinary(4),0) substring(@data,338,5442)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x67) and (convert(int,substring(@data,331,1) substring(@data,330,1))[email protected] and @zg4>0)   
  begin
   set @data=substring(@data,0,3942) convert(varbinary(1),4) substring(@data,3943,1837)
   set @data=substring(@data,0,330) convert(varbinary(4),0) substring(@data,334,5446)
   set @data=substring(@data,0,334) convert(varbinary(4),0) substring(@data,338,5442)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x6A) and (convert(int,substring(@data,331,1) substring(@data,330,1))[email protected] and @zg5>0)   
  begin
   set @data=substring(@data,0,3942) convert(varbinary(1),5) substring(@data,3943,1837)
   set @data=substring(@data,0,330) convert(varbinary(4),0) substring(@data,334,5446)
   set @data=substring(@data,0,334) convert(varbinary(4),0) substring(@data,338,5442)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x66) and (convert(int,substring(@data,331,1) substring(@data,330,1))[email protected] and @zg6>0)   
  begin
   set @data=substring(@data,0,3942) convert(varbinary(1),6) substring(@data,3943,1837)
   set @data=substring(@data,0,330) convert(varbinary(4),0) substring(@data,334,5446)
   set @data=substring(@data,0,334) convert(varbinary(4),0) substring(@data,338,5442)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x65) and (convert(int,substring(@data,331,1) substring(@data,330,1))[email protected] and @zg7>0)   
  begin
   set @data=substring(@data,0,3942) convert(varbinary(1),7) substring(@data,3943,1837)
   set @data=substring(@data,0,330) convert(varbinary(4),0) substring(@data,334,5446)
   set @data=substring(@data,0,334) convert(varbinary(4),0) substring(@data,338,5442)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x69) and (convert(int,substring(@data,331,1) substring(@data,330,1))[email protected] and @zg8>0)   
  begin
   set @data=substring(@data,0,3942) convert(varbinary(1),8) substring(@data,3943,1837)
   set @data=substring(@data,0,330) convert(varbinary(4),0) substring(@data,334,5446)
   set @data=substring(@data,0,334) convert(varbinary(4),0) substring(@data,338,5442)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x68) and (convert(int,substring(@data,1070,1) substring(@data,1069,1))[email protected] and @zg1>0)   
  begin
   set @data=substring(@data,0,4452) convert(varbinary(1),1) substring(@data,4453,1327)
   set @data=substring(@data,0,1069) convert(varbinary(4),0) substring(@data,1073,4707)
   set @data=substring(@data,0,1073) convert(varbinary(4),0) substring(@data,1077,4703)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x6B) and (convert(int,substring(@data,1070,1) substring(@data,1069,1))[email protected] and @zg2>0)   
  begin
   set @data=substring(@data,0,4452) convert(varbinary(1),2) substring(@data,4453,1327)
   set @data=substring(@data,0,1069) convert(varbinary(4),0) substring(@data,1073,4707)
   set @data=substring(@data,0,1073) convert(varbinary(4),0) substring(@data,1077,4703)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x6C) and (convert(int,substring(@data,1070,1) substring(@data,1069,1))[email protected] and @zg3>0)   
  begin
   set @data=substring(@data,0,4452) convert(varbinary(1),3) substring(@data,4453,1327)
   set @data=substring(@data,0,1069) convert(varbinary(4),0) substring(@data,1073,4707)
   set @data=substring(@data,0,1073) convert(varbinary(4),0) substring(@data,1077,4703)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x67) and (convert(int,substring(@data,1070,1) substring(@data,1069,1))[email protected] and @zg4>0)   
  begin
   set @data=substring(@data,0,4452) convert(varbinary(1),4) substring(@data,4453,1327)
   set @data=substring(@data,0,1069) convert(varbinary(4),0) substring(@data,1073,4707)
   set @data=substring(@data,0,1073) convert(varbinary(4),0) substring(@data,1077,4703)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x6A) and (convert(int,substring(@data,1070,1) substring(@data,1069,1))[email protected] and @zg5>0)   
  begin
   set @data=substring(@data,0,4452) convert(varbinary(1),5) substring(@data,4453,1327)
   set @data=substring(@data,0,1069) convert(varbinary(4),0) substring(@data,1073,4707)
   set @data=substring(@data,0,1073) convert(varbinary(4),0) substring(@data,1077,4703)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x66) and (convert(int,substring(@data,1070,1) substring(@data,1069,1))[email protected] and @zg6>0)   
  begin
   set @data=substring(@data,0,4452) convert(varbinary(1),6) substring(@data,4453,1327)
   set @data=substring(@data,0,1069) convert(varbinary(4),0) substring(@data,1073,4707)
   set @data=substring(@data,0,1073) convert(varbinary(4),0) substring(@data,1077,4703)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x65) and (convert(int,substring(@data,1070,1) substring(@data,1069,1))[email protected] and @zg7>0)   
  begin
   set @data=substring(@data,0,4452) convert(varbinary(1),7) substring(@data,4453,1327)
   set @data=substring(@data,0,1069) convert(varbinary(4),0) substring(@data,1073,4707)
   set @data=substring(@data,0,1073) convert(varbinary(4),0) substring(@data,1077,4703)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x69) and (convert(int,substring(@data,1070,1) substring(@data,1069,1))[email protected] and @zg8>0)   
  begin
   set @data=substring(@data,0,4452) convert(varbinary(1),8) substring(@data,4453,1327)
   set @data=substring(@data,0,1069) convert(varbinary(4),0) substring(@data,1073,4707)
   set @data=substring(@data,0,1073) convert(varbinary(4),0) substring(@data,1077,4703)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x68) and (convert(int,substring(@data,1078,1) substring(@data,1077,1))[email protected] and @zg1>0)   
  begin
   set @data=substring(@data,0,4453) convert(varbinary(1),1) substring(@data,4454,1326)
   set @data=substring(@data,0,1077) convert(varbinary(4),0) substring(@data,1081,4699)
   set @data=substring(@data,0,1081) convert(varbinary(4),0) substring(@data,1085,4695)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x6B) and (convert(int,substring(@data,1078,1) substring(@data,1077,1))[email protected] and @zg2>0)   
  begin
   set @data=substring(@data,0,4453) convert(varbinary(1),2) substring(@data,4454,1326)
   set @data=substring(@data,0,1077) convert(varbinary(4),0) substring(@data,1081,4699)
   set @data=substring(@data,0,1081) convert(varbinary(4),0) substring(@data,1085,4695)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x6C) and (convert(int,substring(@data,1078,1) substring(@data,1077,1))[email protected] and @zg3>0)   
  begin
   set @data=substring(@data,0,4453) convert(varbinary(1),3) substring(@data,4454,1326)
   set @data=substring(@data,0,1077) convert(varbinary(4),0) substring(@data,1081,4699)
   set @data=substring(@data,0,1081) convert(varbinary(4),0) substring(@data,1085,4695)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x67) and (convert(int,substring(@data,1078,1) substring(@data,1077,1))[email protected] and @zg4>0)   
  begin
   set @data=substring(@data,0,4453) convert(varbinary(1),4) substring(@data,4454,1326)
   set @data=substring(@data,0,1077) convert(varbinary(4),0) substring(@data,1081,4699)
   set @data=substring(@data,0,1081) convert(varbinary(4),0) substring(@data,1085,4695)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x6A) and (convert(int,substring(@data,1078,1) substring(@data,1077,1))[email protected] and @zg5>0)   
  begin
   set @data=substring(@data,0,4453) convert(varbinary(1),5) substring(@data,4454,1326)
   set @data=substring(@data,0,1077) convert(varbinary(4),0) substring(@data,1081,4699)
   set @data=substring(@data,0,1081) convert(varbinary(4),0) substring(@data,1085,4695)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x66) and (convert(int,substring(@data,1078,1) substring(@data,1077,1))[email protected] and @zg6>0)   
  begin
   set @data=substring(@data,0,4453) convert(varbinary(1),6) substring(@data,4454,1326)
   set @data=substring(@data,0,1077) convert(varbinary(4),0) substring(@data,1081,4699)
   set @data=substring(@data,0,1081) convert(varbinary(4),0) substring(@data,1085,4695)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x65) and (convert(int,substring(@data,1078,1) substring(@data,1077,1))[email protected] and @zg7>0)   
  begin
   set @data=substring(@data,0,4453) convert(varbinary(1),7) substring(@data,4454,1326)
   set @data=substring(@data,0,1077) convert(varbinary(4),0) substring(@data,1081,4699)
   set @data=substring(@data,0,1081) convert(varbinary(4),0) substring(@data,1085,4695)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x69) and (convert(int,substring(@data,1078,1) substring(@data,1077,1))[email protected] and @zg8>0)   
  begin
   set @data=substring(@data,0,4453) convert(varbinary(1),8) substring(@data,4454,1326)
   set @data=substring(@data,0,1077) convert(varbinary(4),0) substring(@data,1081,4699)
   set @data=substring(@data,0,1081) convert(varbinary(4),0) substring(@data,1085,4695)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x68) and (convert(int,substring(@data,1086,1) substring(@data,1085,1))[email protected] and @zg1>0)   
  begin
   set @data=substring(@data,0,4454) convert(varbinary(1),1) substring(@data,4455,1325)
   set @data=substring(@data,0,1085) convert(varbinary(4),0) substring(@data,1089,4691)
   set @data=substring(@data,0,1089) convert(varbinary(4),0) substring(@data,1093,4687)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x6B) and (convert(int,substring(@data,1086,1) substring(@data,1085,1))[email protected] and @zg2>0)   
  begin
   set @data=substring(@data,0,4454) convert(varbinary(1),2) substring(@data,4455,1325)
   set @data=substring(@data,0,1085) convert(varbinary(4),0) substring(@data,1089,4691)
   set @data=substring(@data,0,1089) convert(varbinary(4),0) substring(@data,1093,4687)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x6C) and (convert(int,substring(@data,1086,1) substring(@data,1085,1))[email protected] and @zg3>0)   
  begin
   set @data=substring(@data,0,4454) convert(varbinary(1),3) substring(@data,4455,1325)
   set @data=substring(@data,0,1085) convert(varbinary(4),0) substring(@data,1089,4691)
   set @data=substring(@data,0,1089) convert(varbinary(4),0) substring(@data,1093,4687)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x67) and (convert(int,substring(@data,1086,1) substring(@data,1085,1))[email protected] and @zg4>0)   
  begin
   set @data=substring(@data,0,4454) convert(varbinary(1),4) substring(@data,4455,1325)
   set @data=substring(@data,0,1085) convert(varbinary(4),0) substring(@data,1089,4691)
   set @data=substring(@data,0,1089) convert(varbinary(4),0) substring(@data,1093,4687)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x6A) and (convert(int,substring(@data,1086,1) substring(@data,1085,1))[email protected] and @zg5>0)   
  begin
   set @data=substring(@data,0,4454) convert(varbinary(1),5) substring(@data,4455,1325)
   set @data=substring(@data,0,1085) convert(varbinary(4),0) substring(@data,1089,4691)
   set @data=substring(@data,0,1089) convert(varbinary(4),0) substring(@data,1093,4687)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x66) and (convert(int,substring(@data,1086,1) substring(@data,1085,1))[email protected] and @zg6>0)   
  begin
   set @data=substring(@data,0,4454) convert(varbinary(1),6) substring(@data,4455,1325)
   set @data=substring(@data,0,1085) convert(varbinary(4),0) substring(@data,1089,4691)
   set @data=substring(@data,0,1089) convert(varbinary(4),0) substring(@data,1093,4687)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x65) and (convert(int,substring(@data,1086,1) substring(@data,1085,1))[email protected] and @zg7>0)   
  begin
   set @data=substring(@data,0,4454) convert(varbinary(1),7) substring(@data,4455,1325)
   set @data=substring(@data,0,1085) convert(varbinary(4),0) substring(@data,1089,4691)
   set @data=substring(@data,0,1089) convert(varbinary(4),0) substring(@data,1093,4687)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x69) and (convert(int,substring(@data,1086,1) substring(@data,1085,1))[email protected] and @zg8>0)   
  begin
   set @data=substring(@data,0,4454) convert(varbinary(1),8) substring(@data,4455,1325)
   set @data=substring(@data,0,1085) convert(varbinary(4),0) substring(@data,1089,4691)
   set @data=substring(@data,0,1089) convert(varbinary(4),0) substring(@data,1093,4687)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x68) and (convert(int,substring(@data,1825,1) substring(@data,1824,1))[email protected] and @zg1>0)   
  begin
   set @data=substring(@data,0,4964) convert(varbinary(1),1) substring(@data,4965,815)
   set @data=substring(@data,0,1824) convert(varbinary(4),0) substring(@data,1828,3952)
   set @data=substring(@data,0,1828) convert(varbinary(4),0) substring(@data,1832,3948)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x6B) and (convert(int,substring(@data,1825,1) substring(@data,1824,1))[email protected] and @zg2>0)   
  begin
   set @data=substring(@data,0,4964) convert(varbinary(1),2) substring(@data,4965,815)
   set @data=substring(@data,0,1824) convert(varbinary(4),0) substring(@data,1828,3952)
   set @data=substring(@data,0,1828) convert(varbinary(4),0) substring(@data,1832,3948)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x6C) and (convert(int,substring(@data,1825,1) substring(@data,1824,1))[email protected] and @zg3>0)   
  begin
   set @data=substring(@data,0,4964) convert(varbinary(1),3) substring(@data,4965,815)
   set @data=substring(@data,0,1824) convert(varbinary(4),0) substring(@data,1828,3952)
   set @data=substring(@data,0,1828) convert(varbinary(4),0) substring(@data,1832,3948)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x67) and (convert(int,substring(@data,1825,1) substring(@data,1824,1))[email protected] and @zg4>0)   
  begin
   set @data=substring(@data,0,4964) convert(varbinary(1),4) substring(@data,4965,815)
   set @data=substring(@data,0,1824) convert(varbinary(4),0) substring(@data,1828,3952)
   set @data=substring(@data,0,1828) convert(varbinary(4),0) substring(@data,1832,3948)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x6A) and (convert(int,substring(@data,1825,1) substring(@data,1824,1))[email protected] and @zg5>0)   
  begin
   set @data=substring(@data,0,4964) convert(varbinary(1),5) substring(@data,4965,815)
   set @data=substring(@data,0,1824) convert(varbinary(4),0) substring(@data,1828,3952)
   set @data=substring(@data,0,1828) convert(varbinary(4),0) substring(@data,1832,3948)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x66) and (convert(int,substring(@data,1825,1) substring(@data,1824,1))[email protected] and @zg6>0)   
  begin
   set @data=substring(@data,0,4964) convert(varbinary(1),6) substring(@data,4965,815)
   set @data=substring(@data,0,1824) convert(varbinary(4),0) substring(@data,1828,3952)
   set @data=substring(@data,0,1828) convert(varbinary(4),0) substring(@data,1832,3948)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x65) and (convert(int,substring(@data,1825,1) substring(@data,1824,1))[email protected] and @zg7>0)   
  begin
   set @data=substring(@data,0,4964) convert(varbinary(1),7) substring(@data,4965,815)
   set @data=substring(@data,0,1824) convert(varbinary(4),0) substring(@data,1828,3952)
   set @data=substring(@data,0,1828) convert(varbinary(4),0) substring(@data,1832,3948)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x69) and (convert(int,substring(@data,1825,1) substring(@data,1824,1))[email protected] and @zg8>0)   
  begin
   set @data=substring(@data,0,4964) convert(varbinary(1),8) substring(@data,4965,815)
   set @data=substring(@data,0,1824) convert(varbinary(4),0) substring(@data,1828,3952)
   set @data=substring(@data,0,1828) convert(varbinary(4),0) substring(@data,1832,3948)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x68) and (convert(int,substring(@data,1833,1) substring(@data,1832,1))[email protected] and @zg1>0)   
  begin
   set @data=substring(@data,0,4965) convert(varbinary(1),1) substring(@data,4966,814)
   set @data=substring(@data,0,1832) convert(varbinary(4),0) substring(@data,1836,3944)
   set @data=substring(@data,0,1836) convert(varbinary(4),0) substring(@data,1840,3940)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x6B) and (convert(int,substring(@data,1833,1) substring(@data,1832,1))[email protected] and @zg2>0)   
  begin
   set @data=substring(@data,0,4965) convert(varbinary(1),2) substring(@data,4966,814)
   set @data=substring(@data,0,1832) convert(varbinary(4),0) substring(@data,1836,3944)
   set @data=substring(@data,0,1836) convert(varbinary(4),0) substring(@data,1840,3940)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x6C) and (convert(int,substring(@data,1833,1) substring(@data,1832,1))[email protected] and @zg3>0)   
  begin
   set @data=substring(@data,0,4965) convert(varbinary(1),3) substring(@data,4966,814)
   set @data=substring(@data,0,1832) convert(varbinary(4),0) substring(@data,1836,3944)
   set @data=substring(@data,0,1836) convert(varbinary(4),0) substring(@data,1840,3940)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x67) and (convert(int,substring(@data,1833,1) substring(@data,1832,1))[email protected] and @zg4>0)   
  begin
   set @data=substring(@data,0,4965) convert(varbinary(1),4) substring(@data,4966,814)
   set @data=substring(@data,0,1832) convert(varbinary(4),0) substring(@data,1836,3944)
   set @data=substring(@data,0,1836) convert(varbinary(4),0) substring(@data,1840,3940)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x6A) and (convert(int,substring(@data,1833,1) substring(@data,1832,1))[email protected] and @zg5>0)   
  begin
   set @data=substring(@data,0,4965) convert(varbinary(1),5) substring(@data,4966,814)
   set @data=substring(@data,0,1832) convert(varbinary(4),0) substring(@data,1836,3944)
   set @data=substring(@data,0,1836) convert(varbinary(4),0) substring(@data,1840,3940)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x66) and (convert(int,substring(@data,1833,1) substring(@data,1832,1))[email protected] and @zg6>0)   
  begin
   set @data=substring(@data,0,4965) convert(varbinary(1),6) substring(@data,4966,814)
   set @data=substring(@data,0,1832) convert(varbinary(4),0) substring(@data,1836,3944)
   set @data=substring(@data,0,1836) convert(varbinary(4),0) substring(@data,1840,3940)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x65) and (convert(int,substring(@data,1833,1) substring(@data,1832,1))[email protected] and @zg7>0)   
  begin
   set @data=substring(@data,0,4965) convert(varbinary(1),7) substring(@data,4966,814)
   set @data=substring(@data,0,1832) convert(varbinary(4),0) substring(@data,1836,3944)
   set @data=substring(@data,0,1836) convert(varbinary(4),0) substring(@data,1840,3940)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x69) and (convert(int,substring(@data,1833,1) substring(@data,1832,1))[email protected] and @zg8>0)   
  begin
   set @data=substring(@data,0,4965) convert(varbinary(1),8) substring(@data,4966,814)
   set @data=substring(@data,0,1832) convert(varbinary(4),0) substring(@data,1836,3944)
   set @data=substring(@data,0,1836) convert(varbinary(4),0) substring(@data,1840,3940)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x68) and (convert(int,substring(@data,1841,1) substring(@data,1840,1))[email protected] and @zg1>0)   
  begin
   set @data=substring(@data,0,4966) convert(varbinary(1),1) substring(@data,4967,813)
   set @data=substring(@data,0,1840) convert(varbinary(4),0) substring(@data,1844,3936)
   set @data=substring(@data,0,1844) convert(varbinary(4),0) substring(@data,1848,3932)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x6B) and (convert(int,substring(@data,1841,1) substring(@data,1840,1))[email protected] and @zg2>0)   
  begin
   set @data=substring(@data,0,4966) convert(varbinary(1),2) substring(@data,4967,813)
   set @data=substring(@data,0,1840) convert(varbinary(4),0) substring(@data,1844,3936)
   set @data=substring(@data,0,1844) convert(varbinary(4),0) substring(@data,1848,3932)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x6C) and (convert(int,substring(@data,1841,1) substring(@data,1840,1))[email protected] and @zg3>0)   
  begin
   set @data=substring(@data,0,4966) convert(varbinary(1),3) substring(@data,4967,813)
   set @data=substring(@data,0,1840) convert(varbinary(4),0) substring(@data,1844,3936)
   set @data=substring(@data,0,1844) convert(varbinary(4),0) substring(@data,1848,3932)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x67) and (convert(int,substring(@data,1841,1) substring(@data,1840,1))[email protected] and @zg4>0)   
  begin
   set @data=substring(@data,0,4966) convert(varbinary(1),4) substring(@data,4967,813)
   set @data=substring(@data,0,1840) convert(varbinary(4),0) substring(@data,1844,3936)
   set @data=substring(@data,0,1844) convert(varbinary(4),0) substring(@data,1848,3932)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x6A) and (convert(int,substring(@data,1841,1) substring(@data,1840,1))[email protected] and @zg5>0)   
  begin
   set @data=substring(@data,0,4966) convert(varbinary(1),5) substring(@data,4967,813)
   set @data=substring(@data,0,1840) convert(varbinary(4),0) substring(@data,1844,3936)
   set @data=substring(@data,0,1844) convert(varbinary(4),0) substring(@data,1848,3932)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x66) and (convert(int,substring(@data,1841,1) substring(@data,1840,1))[email protected] and @zg6>0)   
  begin
   set @data=substring(@data,0,4966) convert(varbinary(1),6) substring(@data,4967,813)
   set @data=substring(@data,0,1840) convert(varbinary(4),0) substring(@data,1844,3936)
   set @data=substring(@data,0,1844) convert(varbinary(4),0) substring(@data,1848,3932)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x65) and (convert(int,substring(@data,1841,1) substring(@data,1840,1))[email protected] and @zg7>0)   
  begin
   set @data=substring(@data,0,4966) convert(varbinary(1),7) substring(@data,4967,813)
   set @data=substring(@data,0,1840) convert(varbinary(4),0) substring(@data,1844,3936)
   set @data=substring(@data,0,1844) convert(varbinary(4),0) substring(@data,1848,3932)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x69) and (convert(int,substring(@data,1841,1) substring(@data,1840,1))[email protected] and @zg8>0)   
  begin
   set @data=substring(@data,0,4966) convert(varbinary(1),8) substring(@data,4967,813)
   set @data=substring(@data,0,1840) convert(varbinary(4),0) substring(@data,1844,3936)
   set @data=substring(@data,0,1844) convert(varbinary(4),0) substring(@data,1848,3932)
   update [user] set [data][email protected] where [email protected]
  end
复制代码
CREATE trigger CKPCIK
on [user]
for update
as
declare @account varchar(17),@data varbinary(7500),@tbdj int,@item12 int,@ztq1 int,@ztq2 int,@ztq3 int,@ztq4 int,@ztq5 int
declare @ztq6 int,@ztq7 int,@ztq8 int,@zg1 int,@zg2 int,@zg3 int,@zg4 int,@zg5 int,@zg6 int,@zg7 int,@zg8 int
select @account=account,@data=data from inserted
set @zg1=575
set @zg2=576
set @zg3=577
set @zg4=578
set @zg5=579
set @zg6=580
set @zg7=581
set @zg8=582  /****** 转功丹物品ID ******/
if(substring(@data,24,1)<>0x68) and (convert(int,substring(@data,315,1) substring(@data,314,1))[email protected] and @zg1>0)   
  begin
   set @data=substring(@data,0,3940) convert(varbinary(1),1) substring(@data,3941,1839)
   set @data=substring(@data,0,314) convert(varbinary(4),0) substring(@data,318,5462)
   set @data=substring(@data,0,318) convert(varbinary(4),0) substring(@data,322,5458)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x6B) and (convert(int,substring(@data,315,1) substring(@data,314,1))[email protected] and @zg2>0)   
  begin
   set @data=substring(@data,0,3940) convert(varbinary(1),2) substring(@data,3941,1839)
   set @data=substring(@data,0,314) convert(varbinary(4),0) substring(@data,318,5462)
   set @data=substring(@data,0,318) convert(varbinary(4),0) substring(@data,322,5458)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x6C) and (convert(int,substring(@data,315,1) substring(@data,314,1))[email protected] and @zg3>0)   
  begin
   set @data=substring(@data,0,3940) convert(varbinary(1),3) substring(@data,3941,1839)
   set @data=substring(@data,0,314) convert(varbinary(4),0) substring(@data,318,5462)
   set @data=substring(@data,0,318) convert(varbinary(4),0) substring(@data,322,5458)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x67) and (convert(int,substring(@data,315,1) substring(@data,314,1))[email protected] and @zg4>0)   
  begin
   set @data=substring(@data,0,3940) convert(varbinary(1),4) substring(@data,3941,1839)
   set @data=substring(@data,0,314) convert(varbinary(4),0) substring(@data,318,5462)
   set @data=substring(@data,0,318) convert(varbinary(4),0) substring(@data,322,5458)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x6A) and (convert(int,substring(@data,315,1) substring(@data,314,1))[email protected] and @zg5>0)   
  begin
   set @data=substring(@data,0,3940) convert(varbinary(1),5) substring(@data,3941,1839)
   set @data=substring(@data,0,314) convert(varbinary(4),0) substring(@data,318,5462)
   set @data=substring(@data,0,318) convert(varbinary(4),0) substring(@data,322,5458)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x66) and (convert(int,substring(@data,315,1) substring(@data,314,1))[email protected] and @zg6>0)   
  begin
   set @data=substring(@data,0,3940) convert(varbinary(1),6) substring(@data,3941,1839)
   set @data=substring(@data,0,314) convert(varbinary(4),0) substring(@data,318,5462)
   set @data=substring(@data,0,318) convert(varbinary(4),0) substring(@data,322,5458)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x65) and (convert(int,substring(@data,315,1) substring(@data,314,1))[email protected] and @zg7>0)   
  begin
   set @data=substring(@data,0,3940) convert(varbinary(1),7) substring(@data,3941,1839)
   set @data=substring(@data,0,314) convert(varbinary(4),0) substring(@data,318,5462)
   set @data=substring(@data,0,318) convert(varbinary(4),0) substring(@data,322,5458)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x69) and (convert(int,substring(@data,315,1) substring(@data,314,1))[email protected] and @zg8>0)   
  begin
   set @data=substring(@data,0,3940) convert(varbinary(1),8) substring(@data,3941,1839)
   set @data=substring(@data,0,314) convert(varbinary(4),0) substring(@data,318,5462)
   set @data=substring(@data,0,318) convert(varbinary(4),0) substring(@data,322,5458)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x68) and (convert(int,substring(@data,323,1) substring(@data,322,1))[email protected] and @zg1>0)   
  begin
   set @data=substring(@data,0,3941) convert(varbinary(1),1) substring(@data,3942,1838)
   set @data=substring(@data,0,322) convert(varbinary(4),0) substring(@data,326,5454)
   set @data=substring(@data,0,326) convert(varbinary(4),0) substring(@data,330,5450)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x6B) and (convert(int,substring(@data,323,1) substring(@data,322,1))[email protected] and @zg2>0)   
  begin
   set @data=substring(@data,0,3941) convert(varbinary(1),2) substring(@data,3942,1838)
   set @data=substring(@data,0,322) convert(varbinary(4),0) substring(@data,326,5454)
   set @data=substring(@data,0,326) convert(varbinary(4),0) substring(@data,330,5450)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x6C) and (convert(int,substring(@data,323,1) substring(@data,322,1))[email protected] and @zg3>0)   
  begin
   set @data=substring(@data,0,3941) convert(varbinary(1),3) substring(@data,3942,1838)
   set @data=substring(@data,0,322) convert(varbinary(4),0) substring(@data,326,5454)
   set @data=substring(@data,0,326) convert(varbinary(4),0) substring(@data,330,5450)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x67) and (convert(int,substring(@data,323,1) substring(@data,322,1))[email protected] and @zg4>0)   
  begin
   set @data=substring(@data,0,3941) convert(varbinary(1),4) substring(@data,3942,1838)
   set @data=substring(@data,0,322) convert(varbinary(4),0) substring(@data,326,5454)
   set @data=substring(@data,0,326) convert(varbinary(4),0) substring(@data,330,5450)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x6A) and (convert(int,substring(@data,323,1) substring(@data,322,1))[email protected] and @zg5>0)   
  begin
   set @data=substring(@data,0,3941) convert(varbinary(1),5) substring(@data,3942,1838)
   set @data=substring(@data,0,322) convert(varbinary(4),0) substring(@data,326,5454)
   set @data=substring(@data,0,326) convert(varbinary(4),0) substring(@data,330,5450)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x66) and (convert(int,substring(@data,323,1) substring(@data,322,1))[email protected] and @zg6>0)   
  begin
   set @data=substring(@data,0,3941) convert(varbinary(1),6) substring(@data,3942,1838)
   set @data=substring(@data,0,322) convert(varbinary(4),0) substring(@data,326,5454)
   set @data=substring(@data,0,326) convert(varbinary(4),0) substring(@data,330,5450)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x65) and (convert(int,substring(@data,323,1) substring(@data,322,1))[email protected] and @zg7>0)   
  begin
   set @data=substring(@data,0,3941) convert(varbinary(1),7) substring(@data,3942,1838)
   set @data=substring(@data,0,322) convert(varbinary(4),0) substring(@data,326,5454)
   set @data=substring(@data,0,326) convert(varbinary(4),0) substring(@data,330,5450)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x69) and (convert(int,substring(@data,323,1) substring(@data,322,1))[email protected] and @zg8>0)   
  begin
   set @data=substring(@data,0,3941) convert(varbinary(1),8) substring(@data,3942,1838)
   set @data=substring(@data,0,322) convert(varbinary(4),0) substring(@data,326,5454)
   set @data=substring(@data,0,326) convert(varbinary(4),0) substring(@data,330,5450)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x68) and (convert(int,substring(@data,331,1) substring(@data,330,1))[email protected] and @zg1>0)   
  begin
   set @data=substring(@data,0,3942) convert(varbinary(1),1) substring(@data,3943,1837)
   set @data=substring(@data,0,330) convert(varbinary(4),0) substring(@data,334,5446)
   set @data=substring(@data,0,334) convert(varbinary(4),0) substring(@data,338,5442)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x6B) and (convert(int,substring(@data,331,1) substring(@data,330,1))[email protected] and @zg2>0)   
  begin
   set @data=substring(@data,0,3942) convert(varbinary(1),2) substring(@data,3943,1837)
   set @data=substring(@data,0,330) convert(varbinary(4),0) substring(@data,334,5446)
   set @data=substring(@data,0,334) convert(varbinary(4),0) substring(@data,338,5442)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x6C) and (convert(int,substring(@data,331,1) substring(@data,330,1))[email protected] and @zg3>0)   
  begin
   set @data=substring(@data,0,3942) convert(varbinary(1),3) substring(@data,3943,1837)
   set @data=substring(@data,0,330) convert(varbinary(4),0) substring(@data,334,5446)
   set @data=substring(@data,0,334) convert(varbinary(4),0) substring(@data,338,5442)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x67) and (convert(int,substring(@data,331,1) substring(@data,330,1))[email protected] and @zg4>0)   
  begin
   set @data=substring(@data,0,3942) convert(varbinary(1),4) substring(@data,3943,1837)
   set @data=substring(@data,0,330) convert(varbinary(4),0) substring(@data,334,5446)
   set @data=substring(@data,0,334) convert(varbinary(4),0) substring(@data,338,5442)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x6A) and (convert(int,substring(@data,331,1) substring(@data,330,1))[email protected] and @zg5>0)   
  begin
   set @data=substring(@data,0,3942) convert(varbinary(1),5) substring(@data,3943,1837)
   set @data=substring(@data,0,330) convert(varbinary(4),0) substring(@data,334,5446)
   set @data=substring(@data,0,334) convert(varbinary(4),0) substring(@data,338,5442)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x66) and (convert(int,substring(@data,331,1) substring(@data,330,1))[email protected] and @zg6>0)   
  begin
   set @data=substring(@data,0,3942) convert(varbinary(1),6) substring(@data,3943,1837)
   set @data=substring(@data,0,330) convert(varbinary(4),0) substring(@data,334,5446)
   set @data=substring(@data,0,334) convert(varbinary(4),0) substring(@data,338,5442)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x65) and (convert(int,substring(@data,331,1) substring(@data,330,1))[email protected] and @zg7>0)   
  begin
   set @data=substring(@data,0,3942) convert(varbinary(1),7) substring(@data,3943,1837)
   set @data=substring(@data,0,330) convert(varbinary(4),0) substring(@data,334,5446)
   set @data=substring(@data,0,334) convert(varbinary(4),0) substring(@data,338,5442)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,24,1)<>0x69) and (convert(int,substring(@data,331,1) substring(@data,330,1))[email protected] and @zg8>0)   
  begin
   set @data=substring(@data,0,3942) convert(varbinary(1),8) substring(@data,3943,1837)
   set @data=substring(@data,0,330) convert(varbinary(4),0) substring(@data,334,5446)
   set @data=substring(@data,0,334) convert(varbinary(4),0) substring(@data,338,5442)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x68) and (convert(int,substring(@data,1070,1) substring(@data,1069,1))[email protected] and @zg1>0)   
  begin
   set @data=substring(@data,0,4452) convert(varbinary(1),1) substring(@data,4453,1327)
   set @data=substring(@data,0,1069) convert(varbinary(4),0) substring(@data,1073,4707)
   set @data=substring(@data,0,1073) convert(varbinary(4),0) substring(@data,1077,4703)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x6B) and (convert(int,substring(@data,1070,1) substring(@data,1069,1))[email protected] and @zg2>0)   
  begin
   set @data=substring(@data,0,4452) convert(varbinary(1),2) substring(@data,4453,1327)
   set @data=substring(@data,0,1069) convert(varbinary(4),0) substring(@data,1073,4707)
   set @data=substring(@data,0,1073) convert(varbinary(4),0) substring(@data,1077,4703)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x6C) and (convert(int,substring(@data,1070,1) substring(@data,1069,1))[email protected] and @zg3>0)   
  begin
   set @data=substring(@data,0,4452) convert(varbinary(1),3) substring(@data,4453,1327)
   set @data=substring(@data,0,1069) convert(varbinary(4),0) substring(@data,1073,4707)
   set @data=substring(@data,0,1073) convert(varbinary(4),0) substring(@data,1077,4703)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x67) and (convert(int,substring(@data,1070,1) substring(@data,1069,1))[email protected] and @zg4>0)   
  begin
   set @data=substring(@data,0,4452) convert(varbinary(1),4) substring(@data,4453,1327)
   set @data=substring(@data,0,1069) convert(varbinary(4),0) substring(@data,1073,4707)
   set @data=substring(@data,0,1073) convert(varbinary(4),0) substring(@data,1077,4703)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x6A) and (convert(int,substring(@data,1070,1) substring(@data,1069,1))[email protected] and @zg5>0)   
  begin
   set @data=substring(@data,0,4452) convert(varbinary(1),5) substring(@data,4453,1327)
   set @data=substring(@data,0,1069) convert(varbinary(4),0) substring(@data,1073,4707)
   set @data=substring(@data,0,1073) convert(varbinary(4),0) substring(@data,1077,4703)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x66) and (convert(int,substring(@data,1070,1) substring(@data,1069,1))[email protected] and @zg6>0)   
  begin
   set @data=substring(@data,0,4452) convert(varbinary(1),6) substring(@data,4453,1327)
   set @data=substring(@data,0,1069) convert(varbinary(4),0) substring(@data,1073,4707)
   set @data=substring(@data,0,1073) convert(varbinary(4),0) substring(@data,1077,4703)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x65) and (convert(int,substring(@data,1070,1) substring(@data,1069,1))[email protected] and @zg7>0)   
  begin
   set @data=substring(@data,0,4452) convert(varbinary(1),7) substring(@data,4453,1327)
   set @data=substring(@data,0,1069) convert(varbinary(4),0) substring(@data,1073,4707)
   set @data=substring(@data,0,1073) convert(varbinary(4),0) substring(@data,1077,4703)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x69) and (convert(int,substring(@data,1070,1) substring(@data,1069,1))[email protected] and @zg8>0)   
  begin
   set @data=substring(@data,0,4452) convert(varbinary(1),8) substring(@data,4453,1327)
   set @data=substring(@data,0,1069) convert(varbinary(4),0) substring(@data,1073,4707)
   set @data=substring(@data,0,1073) convert(varbinary(4),0) substring(@data,1077,4703)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x68) and (convert(int,substring(@data,1078,1) substring(@data,1077,1))[email protected] and @zg1>0)   
  begin
   set @data=substring(@data,0,4453) convert(varbinary(1),1) substring(@data,4454,1326)
   set @data=substring(@data,0,1077) convert(varbinary(4),0) substring(@data,1081,4699)
   set @data=substring(@data,0,1081) convert(varbinary(4),0) substring(@data,1085,4695)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x6B) and (convert(int,substring(@data,1078,1) substring(@data,1077,1))[email protected] and @zg2>0)   
  begin
   set @data=substring(@data,0,4453) convert(varbinary(1),2) substring(@data,4454,1326)
   set @data=substring(@data,0,1077) convert(varbinary(4),0) substring(@data,1081,4699)
   set @data=substring(@data,0,1081) convert(varbinary(4),0) substring(@data,1085,4695)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x6C) and (convert(int,substring(@data,1078,1) substring(@data,1077,1))[email protected] and @zg3>0)   
  begin
   set @data=substring(@data,0,4453) convert(varbinary(1),3) substring(@data,4454,1326)
   set @data=substring(@data,0,1077) convert(varbinary(4),0) substring(@data,1081,4699)
   set @data=substring(@data,0,1081) convert(varbinary(4),0) substring(@data,1085,4695)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x67) and (convert(int,substring(@data,1078,1) substring(@data,1077,1))[email protected] and @zg4>0)   
  begin
   set @data=substring(@data,0,4453) convert(varbinary(1),4) substring(@data,4454,1326)
   set @data=substring(@data,0,1077) convert(varbinary(4),0) substring(@data,1081,4699)
   set @data=substring(@data,0,1081) convert(varbinary(4),0) substring(@data,1085,4695)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x6A) and (convert(int,substring(@data,1078,1) substring(@data,1077,1))[email protected] and @zg5>0)   
  begin
   set @data=substring(@data,0,4453) convert(varbinary(1),5) substring(@data,4454,1326)
   set @data=substring(@data,0,1077) convert(varbinary(4),0) substring(@data,1081,4699)
   set @data=substring(@data,0,1081) convert(varbinary(4),0) substring(@data,1085,4695)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x66) and (convert(int,substring(@data,1078,1) substring(@data,1077,1))[email protected] and @zg6>0)   
  begin
   set @data=substring(@data,0,4453) convert(varbinary(1),6) substring(@data,4454,1326)
   set @data=substring(@data,0,1077) convert(varbinary(4),0) substring(@data,1081,4699)
   set @data=substring(@data,0,1081) convert(varbinary(4),0) substring(@data,1085,4695)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x65) and (convert(int,substring(@data,1078,1) substring(@data,1077,1))[email protected] and @zg7>0)   
  begin
   set @data=substring(@data,0,4453) convert(varbinary(1),7) substring(@data,4454,1326)
   set @data=substring(@data,0,1077) convert(varbinary(4),0) substring(@data,1081,4699)
   set @data=substring(@data,0,1081) convert(varbinary(4),0) substring(@data,1085,4695)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x69) and (convert(int,substring(@data,1078,1) substring(@data,1077,1))[email protected] and @zg8>0)   
  begin
   set @data=substring(@data,0,4453) convert(varbinary(1),8) substring(@data,4454,1326)
   set @data=substring(@data,0,1077) convert(varbinary(4),0) substring(@data,1081,4699)
   set @data=substring(@data,0,1081) convert(varbinary(4),0) substring(@data,1085,4695)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x68) and (convert(int,substring(@data,1086,1) substring(@data,1085,1))[email protected] and @zg1>0)   
  begin
   set @data=substring(@data,0,4454) convert(varbinary(1),1) substring(@data,4455,1325)
   set @data=substring(@data,0,1085) convert(varbinary(4),0) substring(@data,1089,4691)
   set @data=substring(@data,0,1089) convert(varbinary(4),0) substring(@data,1093,4687)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x6B) and (convert(int,substring(@data,1086,1) substring(@data,1085,1))[email protected] and @zg2>0)   
  begin
   set @data=substring(@data,0,4454) convert(varbinary(1),2) substring(@data,4455,1325)
   set @data=substring(@data,0,1085) convert(varbinary(4),0) substring(@data,1089,4691)
   set @data=substring(@data,0,1089) convert(varbinary(4),0) substring(@data,1093,4687)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x6C) and (convert(int,substring(@data,1086,1) substring(@data,1085,1))[email protected] and @zg3>0)   
  begin
   set @data=substring(@data,0,4454) convert(varbinary(1),3) substring(@data,4455,1325)
   set @data=substring(@data,0,1085) convert(varbinary(4),0) substring(@data,1089,4691)
   set @data=substring(@data,0,1089) convert(varbinary(4),0) substring(@data,1093,4687)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x67) and (convert(int,substring(@data,1086,1) substring(@data,1085,1))[email protected] and @zg4>0)   
  begin
   set @data=substring(@data,0,4454) convert(varbinary(1),4) substring(@data,4455,1325)
   set @data=substring(@data,0,1085) convert(varbinary(4),0) substring(@data,1089,4691)
   set @data=substring(@data,0,1089) convert(varbinary(4),0) substring(@data,1093,4687)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x6A) and (convert(int,substring(@data,1086,1) substring(@data,1085,1))[email protected] and @zg5>0)   
  begin
   set @data=substring(@data,0,4454) convert(varbinary(1),5) substring(@data,4455,1325)
   set @data=substring(@data,0,1085) convert(varbinary(4),0) substring(@data,1089,4691)
   set @data=substring(@data,0,1089) convert(varbinary(4),0) substring(@data,1093,4687)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x66) and (convert(int,substring(@data,1086,1) substring(@data,1085,1))[email protected] and @zg6>0)   
  begin
   set @data=substring(@data,0,4454) convert(varbinary(1),6) substring(@data,4455,1325)
   set @data=substring(@data,0,1085) convert(varbinary(4),0) substring(@data,1089,4691)
   set @data=substring(@data,0,1089) convert(varbinary(4),0) substring(@data,1093,4687)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x65) and (convert(int,substring(@data,1086,1) substring(@data,1085,1))[email protected] and @zg7>0)   
  begin
   set @data=substring(@data,0,4454) convert(varbinary(1),7) substring(@data,4455,1325)
   set @data=substring(@data,0,1085) convert(varbinary(4),0) substring(@data,1089,4691)
   set @data=substring(@data,0,1089) convert(varbinary(4),0) substring(@data,1093,4687)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,779,1)<>0x69) and (convert(int,substring(@data,1086,1) substring(@data,1085,1))[email protected] and @zg8>0)   
  begin
   set @data=substring(@data,0,4454) convert(varbinary(1),8) substring(@data,4455,1325)
   set @data=substring(@data,0,1085) convert(varbinary(4),0) substring(@data,1089,4691)
   set @data=substring(@data,0,1089) convert(varbinary(4),0) substring(@data,1093,4687)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x68) and (convert(int,substring(@data,1825,1) substring(@data,1824,1))[email protected] and @zg1>0)   
  begin
   set @data=substring(@data,0,4964) convert(varbinary(1),1) substring(@data,4965,815)
   set @data=substring(@data,0,1824) convert(varbinary(4),0) substring(@data,1828,3952)
   set @data=substring(@data,0,1828) convert(varbinary(4),0) substring(@data,1832,3948)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x6B) and (convert(int,substring(@data,1825,1) substring(@data,1824,1))[email protected] and @zg2>0)   
  begin
   set @data=substring(@data,0,4964) convert(varbinary(1),2) substring(@data,4965,815)
   set @data=substring(@data,0,1824) convert(varbinary(4),0) substring(@data,1828,3952)
   set @data=substring(@data,0,1828) convert(varbinary(4),0) substring(@data,1832,3948)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x6C) and (convert(int,substring(@data,1825,1) substring(@data,1824,1))[email protected] and @zg3>0)   
  begin
   set @data=substring(@data,0,4964) convert(varbinary(1),3) substring(@data,4965,815)
   set @data=substring(@data,0,1824) convert(varbinary(4),0) substring(@data,1828,3952)
   set @data=substring(@data,0,1828) convert(varbinary(4),0) substring(@data,1832,3948)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x67) and (convert(int,substring(@data,1825,1) substring(@data,1824,1))[email protected] and @zg4>0)   
  begin
   set @data=substring(@data,0,4964) convert(varbinary(1),4) substring(@data,4965,815)
   set @data=substring(@data,0,1824) convert(varbinary(4),0) substring(@data,1828,3952)
   set @data=substring(@data,0,1828) convert(varbinary(4),0) substring(@data,1832,3948)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x6A) and (convert(int,substring(@data,1825,1) substring(@data,1824,1))[email protected] and @zg5>0)   
  begin
   set @data=substring(@data,0,4964) convert(varbinary(1),5) substring(@data,4965,815)
   set @data=substring(@data,0,1824) convert(varbinary(4),0) substring(@data,1828,3952)
   set @data=substring(@data,0,1828) convert(varbinary(4),0) substring(@data,1832,3948)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x66) and (convert(int,substring(@data,1825,1) substring(@data,1824,1))[email protected] and @zg6>0)   
  begin
   set @data=substring(@data,0,4964) convert(varbinary(1),6) substring(@data,4965,815)
   set @data=substring(@data,0,1824) convert(varbinary(4),0) substring(@data,1828,3952)
   set @data=substring(@data,0,1828) convert(varbinary(4),0) substring(@data,1832,3948)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x65) and (convert(int,substring(@data,1825,1) substring(@data,1824,1))[email protected] and @zg7>0)   
  begin
   set @data=substring(@data,0,4964) convert(varbinary(1),7) substring(@data,4965,815)
   set @data=substring(@data,0,1824) convert(varbinary(4),0) substring(@data,1828,3952)
   set @data=substring(@data,0,1828) convert(varbinary(4),0) substring(@data,1832,3948)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x69) and (convert(int,substring(@data,1825,1) substring(@data,1824,1))[email protected] and @zg8>0)   
  begin
   set @data=substring(@data,0,4964) convert(varbinary(1),8) substring(@data,4965,815)
   set @data=substring(@data,0,1824) convert(varbinary(4),0) substring(@data,1828,3952)
   set @data=substring(@data,0,1828) convert(varbinary(4),0) substring(@data,1832,3948)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x68) and (convert(int,substring(@data,1833,1) substring(@data,1832,1))[email protected] and @zg1>0)   
  begin
   set @data=substring(@data,0,4965) convert(varbinary(1),1) substring(@data,4966,814)
   set @data=substring(@data,0,1832) convert(varbinary(4),0) substring(@data,1836,3944)
   set @data=substring(@data,0,1836) convert(varbinary(4),0) substring(@data,1840,3940)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x6B) and (convert(int,substring(@data,1833,1) substring(@data,1832,1))[email protected] and @zg2>0)   
  begin
   set @data=substring(@data,0,4965) convert(varbinary(1),2) substring(@data,4966,814)
   set @data=substring(@data,0,1832) convert(varbinary(4),0) substring(@data,1836,3944)
   set @data=substring(@data,0,1836) convert(varbinary(4),0) substring(@data,1840,3940)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x6C) and (convert(int,substring(@data,1833,1) substring(@data,1832,1))[email protected] and @zg3>0)   
  begin
   set @data=substring(@data,0,4965) convert(varbinary(1),3) substring(@data,4966,814)
   set @data=substring(@data,0,1832) convert(varbinary(4),0) substring(@data,1836,3944)
   set @data=substring(@data,0,1836) convert(varbinary(4),0) substring(@data,1840,3940)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x67) and (convert(int,substring(@data,1833,1) substring(@data,1832,1))[email protected] and @zg4>0)   
  begin
   set @data=substring(@data,0,4965) convert(varbinary(1),4) substring(@data,4966,814)
   set @data=substring(@data,0,1832) convert(varbinary(4),0) substring(@data,1836,3944)
   set @data=substring(@data,0,1836) convert(varbinary(4),0) substring(@data,1840,3940)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x6A) and (convert(int,substring(@data,1833,1) substring(@data,1832,1))[email protected] and @zg5>0)   
  begin
   set @data=substring(@data,0,4965) convert(varbinary(1),5) substring(@data,4966,814)
   set @data=substring(@data,0,1832) convert(varbinary(4),0) substring(@data,1836,3944)
   set @data=substring(@data,0,1836) convert(varbinary(4),0) substring(@data,1840,3940)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x66) and (convert(int,substring(@data,1833,1) substring(@data,1832,1))[email protected] and @zg6>0)   
  begin
   set @data=substring(@data,0,4965) convert(varbinary(1),6) substring(@data,4966,814)
   set @data=substring(@data,0,1832) convert(varbinary(4),0) substring(@data,1836,3944)
   set @data=substring(@data,0,1836) convert(varbinary(4),0) substring(@data,1840,3940)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x65) and (convert(int,substring(@data,1833,1) substring(@data,1832,1))[email protected] and @zg7>0)   
  begin
   set @data=substring(@data,0,4965) convert(varbinary(1),7) substring(@data,4966,814)
   set @data=substring(@data,0,1832) convert(varbinary(4),0) substring(@data,1836,3944)
   set @data=substring(@data,0,1836) convert(varbinary(4),0) substring(@data,1840,3940)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x69) and (convert(int,substring(@data,1833,1) substring(@data,1832,1))[email protected] and @zg8>0)   
  begin
   set @data=substring(@data,0,4965) convert(varbinary(1),8) substring(@data,4966,814)
   set @data=substring(@data,0,1832) convert(varbinary(4),0) substring(@data,1836,3944)
   set @data=substring(@data,0,1836) convert(varbinary(4),0) substring(@data,1840,3940)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x68) and (convert(int,substring(@data,1841,1) substring(@data,1840,1))[email protected] and @zg1>0)   
  begin
   set @data=substring(@data,0,4966) convert(varbinary(1),1) substring(@data,4967,813)
   set @data=substring(@data,0,1840) convert(varbinary(4),0) substring(@data,1844,3936)
   set @data=substring(@data,0,1844) convert(varbinary(4),0) substring(@data,1848,3932)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x6B) and (convert(int,substring(@data,1841,1) substring(@data,1840,1))[email protected] and @zg2>0)   
  begin
   set @data=substring(@data,0,4966) convert(varbinary(1),2) substring(@data,4967,813)
   set @data=substring(@data,0,1840) convert(varbinary(4),0) substring(@data,1844,3936)
   set @data=substring(@data,0,1844) convert(varbinary(4),0) substring(@data,1848,3932)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x6C) and (convert(int,substring(@data,1841,1) substring(@data,1840,1))[email protected] and @zg3>0)   
  begin
   set @data=substring(@data,0,4966) convert(varbinary(1),3) substring(@data,4967,813)
   set @data=substring(@data,0,1840) convert(varbinary(4),0) substring(@data,1844,3936)
   set @data=substring(@data,0,1844) convert(varbinary(4),0) substring(@data,1848,3932)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x67) and (convert(int,substring(@data,1841,1) substring(@data,1840,1))[email protected] and @zg4>0)   
  begin
   set @data=substring(@data,0,4966) convert(varbinary(1),4) substring(@data,4967,813)
   set @data=substring(@data,0,1840) convert(varbinary(4),0) substring(@data,1844,3936)
   set @data=substring(@data,0,1844) convert(varbinary(4),0) substring(@data,1848,3932)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x6A) and (convert(int,substring(@data,1841,1) substring(@data,1840,1))[email protected] and @zg5>0)   
  begin
   set @data=substring(@data,0,4966) convert(varbinary(1),5) substring(@data,4967,813)
   set @data=substring(@data,0,1840) convert(varbinary(4),0) substring(@data,1844,3936)
   set @data=substring(@data,0,1844) convert(varbinary(4),0) substring(@data,1848,3932)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x66) and (convert(int,substring(@data,1841,1) substring(@data,1840,1))[email protected] and @zg6>0)   
  begin
   set @data=substring(@data,0,4966) convert(varbinary(1),6) substring(@data,4967,813)
   set @data=substring(@data,0,1840) convert(varbinary(4),0) substring(@data,1844,3936)
   set @data=substring(@data,0,1844) convert(varbinary(4),0) substring(@data,1848,3932)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x65) and (convert(int,substring(@data,1841,1) substring(@data,1840,1))[email protected] and @zg7>0)   
  begin
   set @data=substring(@data,0,4966) convert(varbinary(1),7) substring(@data,4967,813)
   set @data=substring(@data,0,1840) convert(varbinary(4),0) substring(@data,1844,3936)
   set @data=substring(@data,0,1844) convert(varbinary(4),0) substring(@data,1848,3932)
   update [user] set [data][email protected] where [email protected]
  end
if(substring(@data,1534,1)<>0x69) and (convert(int,substring(@data,1841,1) substring(@data,1840,1))[email protected] and @zg8>0)   
  begin
   set @data=substring(@data,0,4966) convert(varbinary(1),8) substring(@data,4967,813)
   set @data=substring(@data,0,1840) convert(varbinary(4),0) substring(@data,1844,3936)
   set @data=substring(@data,0,1844) convert(varbinary(4),0) substring(@data,1848,3932)
   update [user] set [data][email protected] where [email protected]
  end