Home / Questions / 141938
Accepted
John Doe
Asked: 2020-02-28 12:01:12 +0800 CST 2020-02-28 12:01:12 +0800 CST

What data type does Tinyint replace in SQL Server?

  • 772

I am trying trying to execute my query in MSSQL but it gives me an error

CREATE TABLE users (
  id INTEGER PRIMARY KEY,
  username VARCHAR(50) NOT NULL,
  password VARCHAR(250) NOT NULL,
  email VARCHAR(80) NOT NULL,
  authKey VARCHAR(250) NOT NULL,
  accessToken VARCHAR(250) NOT NULL,
  activate TINYINT(1) NOT NULL,
  role INTEGER NOT NULL,
);

Mens. 2716, Level 16, State 1, Line 1 Column, parameter, or variable #7: A column width cannot be specified in the tinyint data type.

sql

1 Answers

  1. Best Answer

    To consider:

    | Tipo de datos  |                                             Intervalo                         |    Almacenamiento  |
|----------------|-------------------------------------------------------------------------------|--------------------|
|  bigint        |  De -2^63 (-9.223.372.036.854.775.808) a 2^63-1 (9.223.372.036.854.775.807)   | 8 bytes            |
| int            |  De -2^31 (-2.147.483.648) a 2^31-1 (2.147.483.647)                           | 4 bytes            |
| smallint       |  De -2^15 (-32.768) a 2^15-1 (32.767)                                         | 2 bytes            |
| tinyint        |  De 0 a 255                                                                   | 1 byte             |

    Check the comment in the code:

    CREATE TABLE users (
  id INTEGER PRIMARY KEY,
  username VARCHAR(50) NOT NULL,
  password VARCHAR(250) NOT NULL,
  email VARCHAR(80) NOT NULL,
  authKey VARCHAR(250) NOT NULL,
  accessToken VARCHAR(250) NOT NULL,
  activate TINYINT NOT NULL, --aqui esta la solucion
  role INTEGER NOT NULL
);

    More information: https://docs.microsoft.com/es-es/sql/t-sql/data-types/int-bigint-smallint-and-tinyint-transact-sql

    • 4