字段数
SELECT count(*)
FROM syscolumns where id=yourtableId第N个
select name from syscolumns where colid=N
记录数
select count(*) from yourtable
SELECT count(*)
FROM syscolumns where id=yourtableId第N个
select name from syscolumns where colid=N
记录数
select count(*) from yourtable
第N个
select name from syscolumns where colid=N and id=yourtableId
字段数:SELECT count(*) FROM aaa where id=6 能取到的只能是记录数1
????????????????????????
第N个:select name from aaa where colid=N and id=6根本通不过
????????????????????????
SELECT count(*)
FROM syscolumns where id=yourtableId第N个
select name from syscolumns where colid=N and id=yourtableId再看看,不是从你的AAA表中找的,是在SYSCOLUMNS表中查的。要描述可以到syscomments看看~~~:)
SELECT id
FROM sysobjects
WHERE (name = 'yourTableName')