Data Types Word Search
4September 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.
SQL Studies 
I am able to find 18 only –
BIT, TIME, NVARCHAR, TEXT, VARBINARY, XML, SMALLMONEY, INT, HIERARCHYID, DATETIMEOFFSET, VARCHAR, SMALLINT, DATETIME, TIMESTAMP, FLOAT, NCHAR, TINYINT, CHAR
I’ll be honest, I didn’t save the solution. I somehow missed the option in the program I used. It also appears that the program may have skipped a few and I didn’t notice the option. I was able to find BINARY, MONEY and SQLVARIANT (no underscore). I’ll keep looking for more.
I’ve only found 12 as of the other day – but it’s still fun. Gives me something to do while waiting for execution to complete.
Glad to hear it 🙂 I have to admit I rather enjoyed working on it myself.