sql 创建视图的时候怎么给字段赋值

[baidu_34791896]

select XH as UserId,
SFZJLXM as CardType,
SFZJH as CardNumber,
'' as Source,
XM as Name,
XM as FullName,
XBDM as Sex,
CSRQ as Birthday,
'' as Post,
BH as FatherUnitId,
'' as UnitType,
YDDH as mobile,
DZXX as WebMail,
'' as UnitLevel
from JUST.dbo.T_BKS
在这个里面我想给Source这个字段赋值，怎么做？

[卖水果的net]

如是字符型，不建议使用null和‘’。

[baidu_34791896]

那应该用什么呀？

[中国风]

select XH as UserId, SFZJLXM as CardType, SFZJH as CardNumber, '字段赋值' as Source, XM as Name, XM as FullName, XBDM as Sex, CSRQ as Birthday, '' as Post, BH as FatherUnitId, '' as UnitType, YDDH as mobile, DZXX as WebMail, '' as UnitLevel from JUST.dbo.T_BKS