SQL Server how to set a default value when the column is null -


this sql in sql server:

select user_name ,user_pass ,user_hometown user_baseinfo    

sometimes column can null. when is, want replace default value.

use case

select case            when user_name null "default value"            else user_name         end   table 

Comments

Popular posts from this blog

php - Calling a template part from a post -

Firefox SVG shape not printing when it has stroke -

How to mention the localhost in android -