September 26, 2018 by Kenneth Fisher
Just for fun here is a word search with all of the data types available in SQL Server. Well, two exceptions. No datetime2 because there are no numbers in the word search, and sql_variant I had to remove the underscore. Last but not least, if it helps, there are 33 of them. See if you can find them all without looking any up. If you do need the list here it is. Or you can always query sys.types.
Edit: I have to admit I didn’t save a solution for this. I wasn’t able to find the option in the application I used to create it. It also appears that the application may not have included all of the data types. I was able to find 21 with the following missing:
BIGINT, DATE, DECIMAL, GEOGRAPHY, GEOMETRY, IMAGE, NTEXT, NUMERIC, REAL, SMALLDATETIME, SYSNAME, UNIQUEIDENTIFIER
If you happen to find one of them let me know. I’ll get a key posted next week with whatever I’ve been able to find.