javascript python java c# php android html jquery c++ css ios mysql sql r node.js arrays reactjs c asp.net json ruby-on-rails .net sql-server swift python-3.x objective-c django angular angularjs excel regex pandas ruby iphone ajax linux xml vba asp.net-mvc spring laravel database wordpress typescript string wpf mongodb windows xcode postgresql bash oracle git vb.net amazon-web-services multithreading list firebase flutter eclipse spring-boot dataframe azure react-native algorithm docker macos forms image visual-studio scala powershell function twitter-bootstrap numpy api performance selenium winforms python-2.7 matlab vue.js sqlite apache hibernate entity-framework loops rest shell facebook express android-studio csv linq maven qt swing unit-testing file tensorflow

[ACCEPTED]-Using a IF Statement within a TSQL UPDATE-tsql

Accepted answer
Score: 29

You are looking for the CASE expression:

Column2 = CASE WHEN @NewColumnValue IS NULL THEN 'False' ELSE 'True' END

0

Source: stackoverflow.com

More Related questions

C# - SQLClient - Simplest INSERT

How do I add a Line break in a SQL Server Stored Procedure?

Best way to check for current date in where clause of sql query

How can I resolve my collation conflict in a better way?

How do I drop all foreign-key constraints on a table in Sql Server 2000?

MS SQL Server - When is a CURSOR good?

IF/ELSE Stored Procedure

T-SQL String Replace

SQL Server - CHARINDEX always returns 0

Which one have better performance : Derived Tables or Temporary Tables