Apparently SQL Server (the version that comes with VS 05) really doesn't like statements in the form of Update TheTable set (col1name, col2name) = ('value','value') where col1 = 5
so what's the correct syntax for multiple column updates? (and don't say use parameters, those are a pain)