>Hi,
>
>I need to add a couple of columns to a table (in SQL Server).
>One column will hold a year (e.g. 2024, 2025, and so on). So naturally, numeric(4,0) would do. But, thinking about SQL Server new versions, do new MS SQL Server versions still have Numeric type? If not, would it be better to have the type as Integer?
>Any suggestions would be greatly appreciated.
>
>TIA
All SQL Servers have NUMERIC type.
In your case I would prefer smallint type just because it is 2 bytes and not 4 :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.