set conn=server.create("adodb.connection")
conn.open "看你是什么数据库了,就该用什么,这你知道吧"
set rs=server.create("adodb.recordset")
rs.open "select * from 表名",conn,2,3
do while rs.eof then
for i=0 to rs.fields.count-1
response.write""&rs(i).name&"<br/>"
next
rs.movenext
楼主是取SQL server 里面一个表的所有列?
如果是这样,可以从SQL Server系统表中得到。如下:
SELECT syscolumns.name
FROM syscolumns INNER JOIN
sysobjects ON syscolumns.id = sysobjects.id
WHERE (sysobjects.name = '表名')