update table

#1 (**permalink**) 05-04-2007, 04:27 PM

i need to update 4 columns of a table..
out of dat 3 columns need to updated without any conditions and the 4th one need to updated with a certain condition..
so is there any way to do this in a single query?

#2 (**permalink**) 05-07-2007, 08:10 AM

Quote:

Originally Posted by Unregistered

i need to update 4 columns of a table..
out of dat 3 columns need to updated without any conditions and the 4th one need to updated with a certain condition..
so is there any way to do this in a single query?

What is the 4th column condition?

#3 (**permalink**) 05-07-2007, 08:13 AM

placing the column in a case block will work for you

Update table1
set column1=@value,
column2=@value,
column3=@value,
column4=case (condition) @value Else,column4 End case

#4 (**permalink**) 05-07-2007, 08:26 AM

Quote:

Originally Posted by ankur.bhargava

placing the column in a case block will work for you

Update table1
set column1=@value,
column2=@value,
column3=@value,
column4=case (condition) @value Else,column4 End case

yes!

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

User Name		Remember Me?
Password

update table

ANSWER(S):