Declare @sql Varchar(1000)
Set @sql='Select * from table1 Where '
Select @sql=@sql+Name+' =5 And' from SysColumns Where ID=OBJECT_ID('table1')
Set @sql=Stuff(@sql,Len(@sql)-3,4,'')
EXEC (@sql)
--我改了改“鱼”的
Declare @sql Varchar(1000)
Set @sql='Select * from table Where '
Select @sql=@sql+[Name]+'=5 or ' from SysColumns Where ID=OBJECT_ID('table')
--print @sql
Set @sql=left(@sql,Len(@sql)-3)
EXEC (@sql)