Only update changed columns

Giganews Newsgroups
Subject: Only update changed columns
Posted by:  binder (rgondz…
Date: 15 Aug 2006

I have a stored procedure that inserts values into five columns of a
table. I need another stored procedure that will allow the user to pass
one or more of those parameters and update only the column for the data
that was passed. In other words, the update may only have one or two of
the parameters that was originally provided in the insert. Therefore, I
do not want to update the columns that did not change. What is the
proper way to handle this situation?