http://www.brentozar.com/archive/2009/09/whats-on-my-bookshelf/
CommandText: "UPDATE employees SET empno = ?, ename = ?,
job = ?, mgr = ?, hiredate = ?, sal = ?, comm = ?,
dept = ?
WHERE (
(empno = ?) AND (ename = ?) AND
(job = ?) AND ((mgr IS NULL and ? IS NULL) OR (mgr = ?))
AND (hiredate = ?) AND (sal = ?) AND (
(comm IS NULL AND ? IS NULL) OR
(comm = ?)) AND (dept = ?))"













