Thursday, August 26, 2010
Crossword puzzle for Functions
Try to solve this crossword puzzle for functions. The key is only names of the functions are the answers for this croosword puzzle.
Across
1. Replaces NULL with the specified replacement value.
3. Returns a character expression after it removes leading blanks.
6. Returns a character expression with lowercase character data converted to uppercase.
7. Returns a numeric value, rounded to the specified length or precision.
8. Returns the average of the values in a group. Null values are ignored.
9. Returns the current system date and time.
10. provides a rowset view over an XML document.
Down
2. Returns part of a character, binary, text, or image expression.
4. Replaces all occurrences of a specified string value with another string value.
5. Stored procedures cannot be executed with in this object.
Answer:
Subscribe to:
Post Comments (Atom)
Answers for the Puzzle:
ReplyDelete1. ISNULL
2. SUBSTRING
3. LTRIM
4. REPLACE
5. FUNCTION
6. UPPER
7. ROUND
8. AVG
9. GETDATE
10.OPENXML
Bala, good job.... complicated puzzles are welcome!!