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
Post a Comment