SELECT COUNT(*) AS Expr1 FROM syscolumns , sysobjects WHERE (syscolumns.id = sysobjects.id) and sysobjects.name='yourtablename'就行,sql server 2000调试通过!!!!!!!!1
也可以通过TDataSet.Fields.Count得到
没回答为什么要 distinct * 吧
create procedure fieldcount as SELECT COUNT(*) FROM syscolumns , sysobjects WHERE (syscolumns.id = sysobjects.id) and sysobjects.name='tablename'
方法是对的,不过执行出错:'*"附近有错误,请指点,立即结分
FROM syscolumns , sysobjects
WHERE (syscolumns.id = sysobjects.id) and sysobjects.name='yourtablename'就行,sql server 2000调试通过!!!!!!!!1
as
SELECT COUNT(*) FROM syscolumns , sysobjects
WHERE (syscolumns.id = sysobjects.id) and sysobjects.name='tablename'
Distinct没必要,一个表不会有相同字段的。