SQL Sunday Fun – Word Search with New T-SQL 2012 Functionality
Click on the grid to enlarge, then print it.
Find the following words in the grid up, down, left, right, horizontal, vertical, and diagonal.
| ROWS | RANGE | PRECEDING |
| FOLLOWING | UNBOUNDED | IIF |
| CHOOSE | OFFSET | FETCH |
| FORMAT | CONCAT | SEQUENCE |
| PARSE | TRYPARSE | TRYCONVERT |
| THROW | LEAD | LAG |
| FIRSTVALUE | LASTVALUE | PERCENTRANK |
| CUMEDIST | PERCENTILEDISC | PERCENTILECONT |
NOTE: some of these terms normally have an underscore in them, but for the purpose of the word scramble the underscores have been omitted.
Related Links:
SEQUENCE object
Analytics – Analytic Functions – PERCENT_RANK
Analytics PERCENTILE_DISC and PERCENTILE_CONT
TSQL Analytic Functions LEAD and LAG
OVER clause with ROWS PRECEDING and FOLLOWING in TSQL 2012
OFFSET / FETCH in a SELECT statement
Cumulative Distribution Function (CDF) or as it is known in TSQL CUME_DIST()
More from Stedman Solutions:
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!
Leave a Reply