SELECT name, colid from syscolumns where id = @TableID order by colorder
select a.name, a.colid from syscolumns a join sysobjects b on a.id = b.id where b.xtype='U' and b.name = @tablename order by a.colorder
给你参考 str_Sql="select A.* ,C.ClassName from PE_Article A inner join PE_Class C on A.ClassID=C.ClassID where A.ChannelID="+arrChannelID+" and A.Deleted=0 order by ArticleID desc";
你要找a.dbf表中所有字段,在ms sql server中是 select a.name, a.colid from syscolumns a join sysobjects b on a.id = b.id where b.xtype='U' and b.name = 'dbf'order by a.colorder
返回表的字段名 select name from syscolumns where id=object_id('表名')
我是用ASP.NET,上传一A.DBF表,想用SQL语句提取出它的字段名显示在页面上!!!!
你们用的‘SYSCOLUMNS’不行呀,好像就不能用: Microsoft Jet 数据库引擎找不到对象'syscolumns'。请确定对象是否存在,并正确地写出它的名称和路径
and b.name = @tablename order by a.colorder
str_Sql="select A.* ,C.ClassName from PE_Article A inner join PE_Class C on A.ClassID=C.ClassID where A.ChannelID="+arrChannelID+" and A.Deleted=0 order by ArticleID desc";
select a.name, a.colid from syscolumns a join sysobjects b on a.id = b.id where b.xtype='U' and b.name = 'dbf'order by a.colorder
select name from syscolumns where id=object_id('表名')
Microsoft Jet 数据库引擎找不到对象'syscolumns'。请确定对象是否存在,并正确地写出它的名称和路径