杭州交通信息网沼气发电国家怎么补贴:在SQL2000中怎么用语句查看各字段的属性？
来源：百度文库 编辑：杭州交通信息网 时间：2024/04/29 01:06:20
例如：要查看年龄的数据类型，占用几个字符，怎么查？有SQL语句实现。
VB中可以查..SQL语句好像不行吧.
供参考.
Dim rs As New ADODB.Recordset
Dim fld As ADODB.Field
Dim cn As ADODB.Connection
Dim cmdText As String
cn.Provider = "sqloledb"
cn.Properties("Data Source").Value = "MyServerName"
cn.Properties("Initial Catalog").Value = "northwind"
cn.Properties("Integrated Security").Value = "SSPI"
cn.Open
cmdText = "select * from authors"
rs.Open cmdText, cn
Set Flds = rs.Fields
Dim TotalCount As Integer
TotalCount = Flds.Count
For Each fld In Flds
Debug.Print fld.Name
Debug.Print fld.Type
Debug.Print fld.Value
Next
rs.Close