Friday, August 27, 2010

Crossword Puzzle for Functions1

Try to solve this crossword puzzle. The key is answers are the function names.




Across:


1. Returns the starting position of the first occurrence of a pattern in a specified expression, or zeros if the pattern is not found, on all valid text and character data types.
5. Returns the count (signed integer) of the specified datepart boundaries crossed between the specified startdate and enddate.
8. Returns the smallest integer greater than, or equal to, the specified numeric expression.
9. This function inserts a string into another string. It deletes a specified length of characters in the first string at the start position and then inserts the second string into the first string at the start position.
10. Determines whether a datetime or smalldatetime input expression is a valid date or time value.


Down:
2. Returns a null value if the two specified expressions are equal.
3. Returns the first nonnull expression among its arguments.
4. Repeats a string value a specified number of times.
6. Determines whether an expression is a valid numeric type.
7. Returns the number of rows affected by the last statement.


Answer:

1 comment:

  1. 1. PATINDEX
    2. NULLIF
    3. COALESCE
    4. REPLICATE
    5. DATEDIFF
    6. ISNUMERIC
    7. ROWCOUNT
    8. CEILING
    9. STUFF
    10.ISDATE

    ReplyDelete