27,579
社区成员
发帖
与我相关
我的任务
分享
select * into #tb2 from (select a.name from dbo.syscolumns a,dbo.sysobjects b
where a.xtype=167 and a.id=b.id and b.name='表名') s
declare @sql varchar(1000)
select @sql=isnull(@sql+',','')+name from #tb2
select @sql='select '+@sql+' 表名'
exec (@sql)
select *
from View_rec_judge
where isnumeric(rec_sid)=0
select *
from View_rec_judge
where patindex('%[0-9]%', rec_sid)=0