现在要的条件是和以前正好相反一般语句都这样的select column1 form table where column2 like ''%'+var1+'%'''可是我的column2比变量短,比如说是 "党员" 而变量var1却很长,比如"共产党员,共青团员"等,现在要求把在column2中被var1包含的数据选择出来,和平常要求正好相反,in也不行,怎么办??
调试欢乐多
select column1 from table where exists(select * from (select var1 as column3) a where column3 like '%'+table.column2+'%')
select column1 from table where exists(select * from
(select var1 as column3)
a where column3 like '%'+table.column2+'%')
====================================
下面把第二行代码扩展开来,比如var1有三个值 '001','002','003'那就成了:
====================================
select column1 from table where exists(select * from
(select '001' as column3 union select '002' as column3 union select '003' as columns)
a where column3 like '%'+table.column2+'%')
====================================
select column1 form table
left join b1 on
b1.var1 like ''%'+table.column2+'%'''
Select top 10 name FROM syscolumns where charindex('base',[name])>0name
--------------------------------------
base_schema_ver
@database
@database
@database
@basetable
@base_objid
@database
@databasename
@database
@database_name(所影响的行数为 10 行)