Welcome to WuJiGu Developer Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
1.8k views
in Technique[技术] by (71.8m points)

Converting update statement values dynamically in SQL Server

I have a requirement to convert the value in the update statement dynamically in SQL Server.

For example, if I receive value as 'true', need to convert it as 'enabled' and 'false', then convert it as 'disabled'.

How I need to implement this in SQL Server ?


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

This isn't "conversion"; conversion means when you change the data type of a value, such as from a varchar to an int.

What you want here is simply a CASE expression:

CASE YourValue WHEN 'true' THEN 'enabled'
               WHEN 'false' THEN 'disabled'
END

You could also use an IIF(), which parsed as a CASE expression "under the hood":

IIF(YourValue = 'true','enabled','false')

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to WuJiGu Developer Q&A Community for programmer and developer-Open, Learning and Share

2.1m questions

2.1m answers

33 comments

47.3k users

...