Declare @ integraltype table
(
[Type] sysname,
[Range] varchar (100 ),
Size varchar (50 ),
[. NET Framework type] varchar (50)
);
Insert @ integraltype values
('Sbyte', '-128 to 127', 'signed 8-bit integer', 'System. sbyte '),
('Byte', '0 to 255 ', 'unsigned 8-bit integer', 'System. byte '),
('Shport', '-32,768 to 32,767', 'signed 16-bit integer ', 'System. int16 '),
('Ushort ', '0 to 65,535', 'unsigned 16-bit integer ', 'System. uint16 '),
('Int', '-2,147,483,648 to 2,147,483,647', 'signed 32-bit integer ', 'System. int32 '),
('Uint', '0 to 4,294,967,295 ', 'unsigned 32-bit integer', 'System. uint32 '),
('Long', '-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807', 'signed 64-bit integer ', 'System. int64 '),
('Udlong', '0 to 18,446,744,073,709,551,615 ', 'unsigned 64-bit integer', 'System. uint64 ');
Select * From @ integraltype;