Q
Problem solve Get help with specific problems with your technologies, process and projects.

Combining two updates in one SQL statement

Can I combine the following two updates in one SQL statement using decode?
 UPDATE ALL_comms_link SET LR = 100000 WHERE (((LN)=31 Or (LN)=32)); UPDATE ALL_comms_link SET LR = 14400 WHERE (((LN)=35 Or (LN)=36 Or (LN)=37));

Look up the case function in Books Online. That is all you need.

 

For More Information

This was last published in August 2002

Dig Deeper on Microsoft SQL Server Installation

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close