Updating Multiple columns using one SQL statement!!

Question

Hello I was wondering if Updating Multiple columns using one SQL statement is possible at all???? Here is a sample of what I'm trying to do and it's me a compiler error  two many character in character literal. string strUpdate = UPDATE TranObjProperty TranObjPropValue SET TranObjProperty.Name =' + strName TranObjPropValue .Value =' + strValue + ' where TOID=+id ; It's basically erroring out right after the DOT operator in TranObjPropValue.Value (highlighted in red) and then the rest of the string is all highlighted in red as well. THe compiler error again is  two many character in character literal. Can some one please help??? Thanks Dillon More

raj beniwal · Answer

Yes dillon we can update multiple columns at a time. eg. string strUpdate = Update tbl_PartnerProfile set Height=66 Age=66 where Userid=21 here tbl_PartnerProfile is table name and Age HeightUserid are column name . i hope this will help you.