代码改变世界

随笔档案-2020年7月6日

sql 身份信息显示XXXX

2020-07-06 15:45 by su_hq, 219 阅读, 收藏,
摘要： DECLARE @CreditCardNumber VARCHAR(20)SET @CreditCardNumber = '170202199408103544' SELECT STUFF(@CreditCardNumber, 7, 8,'XXXX') 阅读全文

sql 拼接json

2020-07-06 15:40 by su_hq, 1014 阅读, 收藏,
摘要： select '[' + STUFF(( select top 10 ',{"carnumber":"' + cast(carnumber as varchar) + '"' + ',"goodsno":"' + cast(goodsno as varchar)+ '"' + ',"goods":" 阅读全文