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 / 5 as decimal(18,2)) from L
3、触发器模板
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
alter TRIGGER [dbo].[L] ON [dbo].L
FOR insert,update
AS
if exists(select FBillNo,FText3 from Lwhere ISNULL(FText3,'') <> '' )
BEGIN
END
4、存储过程
alter PROCEDURE [dbo].[BP_SCFsum]
AS
BEGIN
END
5、定义变量
declare @MaxID as int