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