Fun and Games with SQL – Crossword Puzzle 1
All of us are interested in playing games and solving puzzles, why don’t we try the same with sql server. Solve the crossword puzzle with the given clues, in which the terms are related to sql server.
Crossword:
Clues:
Left to Right:
1. A statement which returns userdefined error message(9)
2. A function which divides the result set into a specified number of groups(5)
3. A function which returns the number of characters of the specified string expression(3)
4. Combines each row from one table with each row of the other table(9)
5. Synonyms for ROW(5)Top to Bottom:
2. A SET optition which stop the message number of rows affected(7)
6. A statement that remove all the rows from a table(8)
7. A standard communication protocol to interchange information in a structured format within a distributed environment(4)
8. The process of compiling and breaking the components of stored procedure into various parts(7)
9. Replaces NULL with the specified replacement value(6)Right to Left:
10. Combines the results of two or more queries into a single result as a distinct output(5)
11. A statement evaluates a list of conditions and returns one of the various possible results(4)
12. A keyword matches the given character string with the specified pattern(4)
13. A virtual table that provides access to a subset of columns from one or more tables(4)Bottom to Top:
14. A operator used to transform a set of columns into values(5)
15. An Index that sorts and stores the data rows in the table based on their key values(9)Answers:
ya .. Awesome... It was a good time pass