select distinct a.noteno as 件号 from B inner join A on b.noteno=a.noteno
解决方案 »
- 时间字符串转换成datetime格式如何设置添加当前日期
- sql语言如何查询指定天的数据?!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
- [菜鸟请教]怎么在SQL Server中剔除异常的datetime型数据
- 请帮忙按图设计一个E-R图
- 函数中调用系统存储过程
- 请高手解答!事务提交回滚问题!!!!!!!!
- 一个奇怪的sql查询问题
- 存储过程查询未指定的数据
- 语句请教
- 如何Excel/VisualFoxpro*.dfb/等等用ADO或DAO导如ACCESS的数据库那.
- 此sql语句怎么写?怎么设定?
- SELECT run_time=left(run_time,10) 查询出日期格式的问题!!!!
from B inner join A on b.noteno=a.noteno
select * into #tmp from
(select a.NOTENO,c.*
from A表 a
,(select [name] from syscolumns where id=object_id('A表'))b
left join B表 c
on c.fieldname=b.name)a
set @sql=''
select @sql='(case disstr when '''+disstr+''' then noteno end) ['+disstr+']'
from (select * from #tmp)a
exec('select '+@sql+' from #tmp')
declare @sql varchar(8000)
select * into #tmp from
(select a.NOTENO,c.*
from A表 a
,(select [name] from syscolumns where id=object_id('A表'))b
left join B表 c
on c.fieldname=b.name)a
set @sql=''
select @sql='(case disstr when '''+disstr+''' then noteno end) ['+disstr+']'
from (select * from #tmp)a
exec('select '+@sql+' from #tmp')
drop table #tmp
set @sql=''
select @sql=@sql+','+FIELDNAME+' as '+DISSTR from t1
set @sql=stuff(@sql,1,1,'')
exec('select '+@sql+' from t')
insert A表 select '001','张三',getdate()
union all select '002','李四','2003-5-13'
union all select '003','王五','2006-7-2'create table B表 (fieldname varchar(20),disstr varchar(50))
insert B表 select 'noteno','件号'
union all select 'wdate','完成时间'declare @sql varchar(8000)
set @sql=''
select @sql=@sql+a.[name]+' as ['+isnull(b.disstr,a.[name])+'],' from syscolumns a
left join B表 b
on a.[name]=b.fieldname
where a.id=object_id('A表')
order by a.colidselect @sql=left(@sql,len(@sql)-1)
print @sql
exec('select '+@sql+' from A表')drop table A表,B表