code:
/********************************************/ /* CREATE PROC HYEY.WL 09-06-23 */ /********************************************/ --T-sql 查询 SELECT * FROM dbo.TabTest --删除表中内容 --TRUNCATE TABLE dbo.TabTest -- 要创建存储过程的数据库 USE Northwind -- 判断要创建的存储过程名是否存在 IF(Select name From sysobjects Where name ='MyTestProc' And Type='p') -- 删除存储过程 Drop Procedure dbo.MyTestProc GO -- 创建存储过程 CREATE PROC dbo.MyTestProc -- 存储过程参数 @sumPrice money AS set @sumPrice = 1.1 -- 存储过程语句体 SELECT @sumPrice=SUM(testNum) from dbo.TabTest SELECT testID , cast(cast(str(SUM(testNum)/@sumPrice*100,5,2) as varchar)as varchar)+'%' AS Per INTO #TempPer FROM dbo.TabTest GROUP BY testID SELECT * FROM #TempPer -- 执行 GO -- 执行存储过程 EXEC MyTestProc GO --EXEC csp_AddInfo 'Junn.A','123456',20,'男' DECLARE @sumPrice MONEY EXEC MyTestProc @sumPrice --Test PROC DECLARE @sumPrice MONEY SELECT @sumPrice=SUM(testNum) from dbo.TabTest SELECT testID ,SUM(testNum)/@sumPrice AS Per INTO #TempPer FROM dbo.TabTest GROUP BY testID SELECT * FROM #TempPer --Test WL one declare @data as decimal(18,5) set @data = 0.12345 select cast(cast(@data * 100 as decimal(18,2)) as varchar(10)) + '%' as 结果 --Test WL two declare @a decimal(15,4) set @a=.1234 select cast(cast(@a*100 as varchar)as varchar)+'%' select cast(cast(str(@a*100,5,2) as varchar)as varchar)+'%'
快速评论通道--您对本文的宝贵意见:
感谢您的鼓励和批评,它将是我进步的动力
感谢您的鼓励和批评,它将是我进步的动力