Ninja's_RGR'us is absolutely correct (as he always is) in his syntax and use of CASE in a DELETE statement. However, it doesn't address the question of if you should...

Collation issues can be very simple or very complex. Collations are implemented at fairly granular levels of database objects, but are defaulted at higher levels (database / server level).

What's...

As was said above, there is no time in SQL without a date.

Because SQL uses DATETIME instead of having DATE and TIME as separate data types, you must consider two...

freddie-897605 (4/12/2011)

---

Better still, write function2 to call function 1 when only 2 parameters were passed. In that way, the existing code can continue to use function1 and the new code...

Consider creating a new UDF with your new optional parameter, then rewriting your original UDF to call that new UDF.

Example:

You had this:

dbo.CustomFunction1(parameter1, parameter2)

Create this:

dbo.CustomFunction2(parameter1, parameter2,...