Data Types Word Search

4

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.

4 thoughts on “Data Types Word Search

  1. Ashish Bhatia says:

    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.

  2. IM Fletcher says:

    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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 2,461 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013
%d bloggers like this: