10 2011 档案
SQL SERVER 查询一个表有多少列
摘要:selectcount(1)fromsyscolumnswhereid=object_id('tbname')或者select*fromsyscolumnswhereid=object_id('tbname')或SELECTMAX(colid)FROMsyscolumnsWHEREid=OBJECT_ID('table') 阅读全文
posted @ 2011-10-19 10:22 sunjun0427 阅读(3987) 评论(0) 推荐(0)