Overblog
Follow this blog Administration + Create my blog

CASE Statement in Update Queries

September 7 2009 , Written by Balavardhan Reddy Published on #SQL Server2005

We can implement CASE statement in Update Queries. Instead of multiple update queries, you can implement multile condition by CASE statement to update a table or get the customized result. Ex : We have a table called Tmp_Tab with column as (PRIORITY,IsUpdated...

Read more