select C.name as Columnname,O.Name as Tablename,S.name as typename,S.Length from dbo.syscolumns C Inner Join dbo.systypes s On C.xtype=s.xtype inner Join dbo.sysobjects O On O.id=C.id where O.name='表名' and C.name='列名'
用dataset返回Typename(类型)和length(长度)即可!
select C.name as Columnname,O.Name as Tablename,S.name as typename,S.Length from dbo.syscolumns C Inner Join dbo.systypes s On C.xtype=s.xtype inner Join dbo.sysobjects O On O.id=C.id where O.name='表名' and C.name='列名' 英雄所见略同。
Inner Join dbo.systypes s On C.xtype=s.xtype
inner Join dbo.sysobjects O On O.id=C.id
where O.name='表名' and C.name='列名'
Inner Join dbo.systypes s On C.xtype=s.xtype
inner Join dbo.sysobjects O On O.id=C.id
where O.name='表名' and C.name='列名'
英雄所见略同。