talkweb 发表于 2009-9-22 16:31:33

7套代码!!

==战神                              

select * from item wheresubstring(CAST(num as varchar(9)),0,8)='2070010'
select * from item wheresubstring(CAST(num as varchar(9)),0,8)='2070020'
select * from item wheresubstring(CAST(num as varchar(9)),0,8)='2070030'
select * from item wheresubstring(CAST(num as varchar(9)),0,8)='2070040'
select * from item wheresubstring(CAST(num as varchar(9)),0,8)='2070050'

==祭祀7套                           

select * from item wheresubstring(CAST(num as varchar(9)),0,8)='2870010'
select * from item wheresubstring(CAST(num as varchar(9)),0,8)='2870020'
select * from item wheresubstring(CAST(num as varchar(9)),0,8)='2870030'
select * from item wheresubstring(CAST(num as varchar(9)),0,8)='2870040'
select * from item wheresubstring(CAST(num as varchar(9)),0,8)='2870050'

==浪人7套                           

select * from item wheresubstring(CAST(num as varchar(9)),0,8)='2470010'
select * from item wheresubstring(CAST(num as varchar(9)),0,8)='2470020'
select * from item wheresubstring(CAST(num as varchar(9)),0,8)='2470030'
select * from item wheresubstring(CAST(num as varchar(9)),0,8)='2470040'
select * from item wheresubstring(CAST(num as varchar(9)),0,8)='2470050'


==FS                        

select * from item wheresubstring(CAST(num as varchar(9)),0,8)='2670010'
select * from item wheresubstring(CAST(num as varchar(9)),0,8)='2670020'
select * from item wheresubstring(CAST(num as varchar(9)),0,8)='2670030'
select * from item wheresubstring(CAST(num as varchar(9)),0,8)='2670040'
select * from item wheresubstring(CAST(num as varchar(9)),0,8)='2670050'

w222222 发表于 2009-9-29 08:39:46

这是干嘛的？

softbbq 发表于 2009-10-2 18:06:22

{:1_205:}

受了。。。。
页: [1]
查看完整版本: 7套代码!!