select b.name + ', ', c.name +' (' + cast(b.length as varchar) + ')', 'Rs.Fields(' + cast((b.colid - 1) as varchar)
+ ')'
from dbo.sysobjects a, dbo.syscolumns b, dbo.systypes c
where a.id = b.id and a.name = 'Email게시판' and b.xtype = c.xtype
order by colid
'database > mssql' 카테고리의 다른 글
| (Transact-SQL) (0) | 2012.03.22 |
|---|---|
| open query (0) | 2012.03.22 |
| MSSQL 2005 Express 외부 접속 (0) | 2012.03.22 |
| SQL Server Management Studio Express 인스턴스명 (0) | 2012.03.22 |
| MSSQL 2005 Express 설정 변경 (0) | 2012.03.22 |