cpu0606的博客

declare @a varchar (20)select @a='2021'if object_id(N'tempdb..#t',N'U') is not nulldrop table #tcreate table #t (rq datetime)declare @b datetimeselect @b=(select DATEADD (year, DATEDIFF(year,0,@a),0))while @b<(select DATEADD(year, DATEDIFF (year,

1、两数相除保留两位小数，输出百分比%convert(varchar,CONVERT(decimal(18, 2),A*(100) * 1.0 / B))+'%' from L以上结果：A/B=C% ，除数*100*1.0，必须转换小数2、sql计算除法保留两位小数select cast(10*1.0 / 5as decimal(18,2)) fromL3、触发器模板...