菜单 学习猿地 - LMONKEY

VIP

开通学习猿地VIP

尊享10项VIP特权 持续新增

知识通关挑战

打卡带练!告别无效练习

接私单赚外块

VIP优先接,累计金额超百万

学习猿地私房课免费学

大厂实战课仅对VIP开放

你的一对一导师

每月可免费咨询大牛30次

领取更多软件工程师实用特权

入驻
49
0

SQL Server将两个字段数据合并成一个字段显示(字段与字段添加特殊符号)减号 中括号 小括号

原创
05/13 14:22
阅读数 31441
--用中括号实现两个字段组合成一个并显示
select Phone  as 手机号,
 (CAST(Name  as varchar(20))+'['+ CAST (ShopNo as varchar(20))+']')
  as 姓名工号
 From Shopping (NOLOCK) t order by CreateDate desc
 --用括号实现两个字段组合成一个并显示
 select Phone  as 手机号,
 (CAST(Name  as varchar(20))+'('+ CAST (ShopNo as varchar(20))+')')
  as 姓名工号
 From Shopping (NOLOCK) t order by CreateDate desc

 --用减号实现两个字段组合成一个并显示
 select Phone  as 手机号,
 (CAST(Name  as varchar(20))+'-'+ CAST (ShopNo as varchar(20)))
  as 姓名工号
 From Shopping (NOLOCK) t order by CreateDate desc

 

发表评论

0/200
49 点赞
0 评论
收藏