SQL Server 2005 得到某个表中某字段的数据类型
1 /// <summary>
2 /// 得到某个表中某字段的数据类型 例如:DateTime,Varchar,int,![](https://www.cnblogs.com/Images/dot.gif)
3 /// </summary>
4 /// <param name="sTableName">表名</param>
5 /// <param name="sFieldName">字段名</param>
6 /// <returns></returns>
7 public string GetFieldDataType(string sTableName, string sFieldName)
8 {
9 string sSQL;
10 string sDataType;
11 sSQL =" select sys.types.name typeName ";
12 sSQL+=" from sys.syscolumns ";
13 sSQL+=" inner join sys.types ";
14 sSQL+=" on sys.types.system_type_id=sys.syscolumns.xtype ";
15 sSQL += " where object_id('"+sTableName+"')=id and sys.syscolumns.name='"+sFieldName+"' ";
16 DataTable objDt = oDBConn.GetDataTable(sSQL);
17 if (objDt.Rows.Count > 0)
18 sDataType = objDt.Rows[0]["typeName"].ToString().Trim();
19 else
20 sDataType = "";
21 return sDataType;
22 }
2 /// 得到某个表中某字段的数据类型 例如:DateTime,Varchar,int,
![](https://www.cnblogs.com/Images/dot.gif)
3 /// </summary>
4 /// <param name="sTableName">表名</param>
5 /// <param name="sFieldName">字段名</param>
6 /// <returns></returns>
7 public string GetFieldDataType(string sTableName, string sFieldName)
8 {
9 string sSQL;
10 string sDataType;
11 sSQL =" select sys.types.name typeName ";
12 sSQL+=" from sys.syscolumns ";
13 sSQL+=" inner join sys.types ";
14 sSQL+=" on sys.types.system_type_id=sys.syscolumns.xtype ";
15 sSQL += " where object_id('"+sTableName+"')=id and sys.syscolumns.name='"+sFieldName+"' ";
16 DataTable objDt = oDBConn.GetDataTable(sSQL);
17 if (objDt.Rows.Count > 0)
18 sDataType = objDt.Rows[0]["typeName"].ToString().Trim();
19 else
20 sDataType = "";
21 return sDataType;
22 }