如何检查SQL中表的任何列中是否存在值

一种方法是通过反转

In

select * from yourtable where 'Myval' in (col1,col2,col3,...)

如果您不想手动输入列，则使用该列

dynamic sql

declare @sql varchar(max)='select * from yourtable where ''Myval'' in ('select @sql+=quotename(column_name)+',' from INFORMATION_SCHEMA.COLUMNSwhere TABLE_NAME='yourtable'select @sql =left(@sql,len(@sql)-1)+')'--print @sqlexec sp_executesql @sql