Bob,
>To do that, woouldn't you need to use dynamic SQL? As the link that Sergey gave you someone stated, the overhead of doing dynamic SQL in the SP would eliminate any speed advantage using the SP would give you.<Yeah, I hadn't even thought of that until I read Sergey's link ... so, I guess it boils down to just updating everything all the time. No problem ...
Thanks, guys ...
>>I'm trying to avoid an Update SP that updates *every* column and instead have an SP that only updates what is sent to it.
>>
>>~~Bonnie
>
>To do that, woouldn't you need to use dynamic SQL? As the link that Sergey gave you someone stated, the overhead of doing dynamic SQL in the SP would eliminate any speed advantage using the SP would give you. Of course, if you are only using the SP fo security reasons, I guess you could do it.
>
>Also, if you want you could build the SET part of the UPDATE statement in the client and send that as one string to the SP, which would then build the final update statement and EXEC() it.
>
>BOb