I would think that it should work fine with commas, if it were between a pair of apostrophes SQL should know that it is part of a string. Hell, maybe that really is the way that it works, and I ...

I'd like to know that a NULL is going to be inserted into a non-nullable field on one row via RAISEERROR, skip that row's update, and then allow the SQL statement to continue.

If you ever need to sort character strings stored in SQL Server fields, check out this demonstration of how to write a common sorting algorithm using SQL Server TSQL code.

As we saw in the last article, the SQL SELECT statement has the widest variety of query options, which are used to control the way data is returned. These options come in the form of clauses ...