select xtype, (case xtype
WHEN 34 THEN 'image'
WHEN 35 THEN 'text'
WHEN 36 THEN 'uniqueidentifier'
WHEN 40 THEN 'date'
WHEN 41 THEN 'time'
WHEN 42 THEN 'datetime2'
WHEN 48 THEN 'tinyint'
WHEN 52 THEN 'smallint'
WHEN 56 THEN 'int'
WHEN 58 THEN 'smalldatetime'
WHEN 59 THEN 'real'
WHEN 60 THEN 'money'
WHEN 61 THEN 'datetime'
WHEN 62 THEN 'float'
WHEN 98 THEN 'sql_variant'
WHEN 99 THEN 'ntext'
WHEN 104 THEN 'bit'
WHEN 106 THEN 'decimal'
WHEN 108 THEN 'numeric'
WHEN 122 THEN 'smallmoney'
WHEN 127 THEN 'bigint'
WHEN 165 THEN 'varbinary'
WHEN 167 THEN 'varchar'
WHEN 173 THEN 'binary'
WHEN 175 THEN 'char'
WHEN 189 THEN 'timestamp'
WHEN 231 THEN 'nvarchar'
WHEN 239 THEN 'nchar'
WHEN 241 THEN 'xml'
end) Tipo, count(*)
from syscolumns
group by xtype
order by xtype
select xtype, (case xtype WHEN 34 THEN 'image' WHEN 35 THEN 'text' WHEN 36 THEN 'uniqueidentifier'
WHEN 40 THEN 'date' WHEN 41 THEN 'time' WHEN 42 THEN 'datetime2' WHEN 48 THEN 'tinyint' WHEN 52 THEN 'smallint' WHEN 56 THEN 'int' WHEN 58 THEN 'smalldatetime' WHEN 59 THEN 'real' WHEN 60 THEN 'money' WHEN 61 THEN 'datetime' WHEN 62 THEN 'float' WHEN 98 THEN 'sql_variant' WHEN 99 THEN 'ntext' WHEN 104 THEN 'bit' WHEN 106 THEN 'decimal' WHEN 108 THEN 'numeric' WHEN 122 THEN 'smallmoney' WHEN 127 THEN 'bigint' WHEN 165 THEN 'varbinary' WHEN 167 THEN 'varchar' WHEN 173 THEN 'binary' WHEN 175 THEN 'char' WHEN 189 THEN 'timestamp' WHEN 231 THEN 'nvarchar' WHEN 239 THEN 'nchar' WHEN 241 THEN 'xml' end) Tipo, count(*) from syscolumns group by xtype order by xtype
34 image 35 text 36 uniqueidentifier 48 tinyint 52 smallint 56 int 58 smalldatetime 61 datetime 62 float 98 sql_variant 104 bit 106 decimal 127 bigint 165 varbinary 167 varchar 173 binary 175 char 189 timestamp 231 nvarchar 239 nchar