把第二行的tb改成你的art即可: DECLARE @TableName varchar(100) set @TableName = 'tb'DECLARE @sql varchar(8000) set @sql = '' Select @sql = @sql + '[' + Name + '] like ''xx'' OR ' from SysColumns Where id=Object_Id(@TableName) set @sql = 'select * from ' + @TableName + ' where ' + left(@sql, LEN(@sql)-3)exec (@sql)
楼主表述的不够清楚啊!呵呵 DECLARE @TableName varchar(100) set @TableName = 'tb'DECLARE @sql varchar(8000) set @sql = '' Select @sql = @sql + '[' + Name + '] like ''%中国%'' OR ' from SysColumns Where id=Object_Id(@TableName) set @sql = 'select * from ' + @TableName + ' where ' + left(@sql, LEN(@sql)-3) select @sql exec (@sql)
select * from art where charindex('中国' , title) > 0
DECLARE @TableName varchar(100)
set @TableName = 'tb'DECLARE @sql varchar(8000)
set @sql = ''
Select @sql = @sql + '[' + Name + '] like ''xx'' OR ' from SysColumns Where id=Object_Id(@TableName)
set @sql = 'select * from ' + @TableName + ' where ' + left(@sql, LEN(@sql)-3)exec (@sql)
DECLARE @TableName varchar(100)
set @TableName = 'tb'DECLARE @sql varchar(8000)
set @sql = ''
Select @sql = @sql + '[' + Name + '] like ''%中国%'' OR ' from SysColumns Where id=Object_Id(@TableName)
set @sql = 'select * from ' + @TableName + ' where ' + left(@sql, LEN(@sql)-3)
select @sql
exec (@sql)