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).
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 any size.
Learn more »