unsigned
or signed
int64
insteadThe SQL cast
specification converts a value to the named data type.
SELECT CAST(column_name AS SMALLINT
)
FROM …
Smallint
in other places: column type.
Product specific cast functions: try_cast
, safe_cast
, ::
, convert
.
ISO/IEC 9075:2016-2 defines smallint
(E011-01, “INTEGER
and SMALLINT
data types (including all spellings)”) and the cast
specification (F201).
You can’t catch up on 20 years of SQL evolution in one day. Subscribe the newsletter via E-Mail, Twitter or RSS to gradually catch up and to keep modern-sql.com on your radar.
The essence of SQL tuning in 200 pages
Buy now!
(paperback and/or PDF)
Paperback also available at Amazon.com.
Markus offers SQL training and consulting for developers working at companies of all sizes.
Learn more »