Question

SQL 如何用like模糊子查询

SQL语句：select * from a where [name] like +'%'+(select top 1 code from b ) +'%'
请高手们麻烦看看这个语句是否有误，小女子不胜感激！

Answer 1

select * from a where [name] like (select top 1 '%'+convert(varchar(200),code)+'%' from b )

查询分析器中测试通过
程序中的话要保证传递给sql的是这个

Answer 2

select * from albumm where name like '%'+(select top 1 name from albumm)+'%'

sql server2000中没错，我查出的是（中本身的记录）
如果有问题可以HI我

Answer 3

select * from a where [name] like '%+(select top 1 code from b ) +%'
这样就行了

Answer 4

select * from awhere [name] like '% (select top 1 code from b) %'