--查询:declare @s varchar(8000)
set @s=''
select @s=@s+',['+b.fTitle+']=['+b.fName+']'
from b join syscolumns a
on a.name=b.fname and id=object_id('a')
group by b.fName,b.fTitle
order by min(colid)set @s=stuff(@s,1,1,'')
exec('select '+@s+' from a')
set @s=''
select @s=@s+',['+b.fTitle+']=['+b.fName+']'
from b join syscolumns a
on a.name=b.fname and id=object_id('a')
group by b.fName,b.fTitle
order by min(colid)set @s=stuff(@s,1,1,'')
exec('select '+@s+' from a')
我想好好恶补一下!
http://www.pdown.net/download.asp?downid=2&id=1035sqlserver 2000 程序员指南
http://www.pdown.net/download.asp?downid=2&id=143http://www.pdown.net/ 这个网站有几本书还算过得去吧.个人观点先看一些书,掌握基础
再找问题来练(本站就大把问题,还有大把解决方法)然后再看深层次的书,再练不明白的也多看联机帮助
如果我想在以上搜索中加入具体的条件该怎么做啊?
比如:age>20的记录就显示"姓名"和"地址"
exec('select '+@s+' from a where 条件')
set @s=''
select @s=@s+',['+b.fTitle+']=['+b.fName+']'
from b join syscolumns a
on a.name=b.fname and id=object_id('a')
where b.fName in('NAME','ADDRESS')
group by b.fName,b.fTitle
order by min(colid)set @s=stuff(@s,1,1,'')
exec('select '+@s+' from a WHERE AGE>20')
打不开