Question

sql格式化字符串如何弄

select '0' cast(1 as varchar(1))

Answer 1

用convertselect convert(varchar(10),1) --将1转换为字符串

Answer 2

select REPLICATE('0',8-LEN (CardNo))+CardNo from ZlEmployee
REPLICATE为替换函数 len测量字符长度

Answer 3

强行加吧select a='0' cast(1 as varchar(5))