Update column using case expression sql

Question

I want to set column value only if it is not blank.

Here is sample

Declare @Temp Varchar(20)

Update Logins
Set ColValue = 
Case When @Temp <> '' Then @Temp Else /* Dont SET Value */ End
Where Code=1

What to write in Else Part ?

I have multiple columns to update and want to apply condition in only single column

DB : SQL SERVER 2008

http://stackoverflow.com/questions/14762374/how-do-i-use-case-in-sql-for-my-example may this help you — gasroot, May 28 '13 at 08:56

Robert · Accepted Answer · 2013-05-28T08:58:58.053

3

You have to set the updated column as below:

Declare @Temp Varchar(20)

Update Logins
Set ColValue = Case When @Temp <> '' Then @Temp 
                    Else ColValue 
               End
Where Code=1

edited May 28 '13 at 08:58

answered May 28 '13 at 08:51

Robert

25,425
8
67
81

score 0 · Answer 2 · answered May 28 '13 at 08:56

0

You can check your variable in WHERE to not update at all when it's blank

Declare @Temp Varchar(20)

Update Logins
Set ColValue = @Temp
Where Code=1 AND @Temp <> ''

answered May 28 '13 at 08:56

Nenad Zivkovic

18,221
6
42
55

I have multiple columns to update and want to apply condition in only single column – Shaggy May 28 '13 at 08:59
1

@SagarDumbre Well, in that case, use other solution with `ELSE ColValue` in CASE :) – Nenad Zivkovic May 28 '13 at 09:03

Update column using case expression sql

2 Answers2