Data Types Word Search4
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.
Category: DBA Humor, Microsoft SQL Server, SQLServerPedia Syndication | Tags: data types, Humor, Microsoft SQL Server
4 thoughts on “Data Types Word Search”
Leave a Reply Cancel reply
This site uses Akismet to reduce spam. Learn how your comment data is processed.
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.