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:


1 comment:

  1. Answers for the Puzzle:

    1. 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!!

    ReplyDelete