Tinyint - TSQL Tutorial

On Transact SQL language the tinyint is an numeric data type. The maximum value of tinyint data type is 255.

Tinyint syntax:

RangeStorage
0 to 2551 Byte

Tinyint example:

USE model;
GO
CREATE TABLE myTinyintTable ( d tinyint );
GO
INSERT INTO myTinyintTable VALUES (255);
GO
SELECT d FROM myTinyintTable;
GO

Results
255