各位哥们,这是什么问题???

我在SQL server中执行如下命令:
select name from sysobjects where name like '%'+'member'+''+'w123456' +'__%'

为什么返回的值如下??
DF__member__w123456__62458BBE
DF__member__w1234567__642DD430

其中:DF__member__w1234567__642DD430
是怎么选出来的啊???怎么去掉这个赖子???
---------------------------------------------------------------

因为'_'是作为单个的通配符啊,当然就选出来了
---------------------------------------------------------------

你试试这样
select name form sysobjects where name like '%[][]member[][]w123456[][]%'

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus