Sql存储过程代码优化

2012-01-19 06:10:16 137 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

CANdelaStudio实战：如何用19服务快速编辑DTC快照数据（附Excel模板）本文详细介绍了在CANdelaStudio中利用19服务高效编辑DTC快照数据的进阶技巧。通过导出DTC池至Excel进行批量编辑，结合‘Copy from DTC Pool’功能实现配置复用，并分享了构建自定义Excel模板与字段映射的实用方法，帮助工程师将繁琐的手动配置转化为工程化的批量处理，大幅提升诊断数据库开发效率。阅读详情

请大家看看，我下面这个过程还能优化吗（简洁和效率）？

USE [price]

GO

/****** Object:  StoredProcedure [dbo].[getprice]    Script Date: 01/19/2012 18:04:05 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[getprice] 

@DT nvarchar(20),@PM nvarchar(20),@GG int,@CZ int,@CD int

AS

BEGIN

	SET NOCOUNT ON;



declare @pri1 int

declare @pri2 float

declare @pri3 float

declare @pri4 float

declare @price float

set @price=0

select  @pri1=AVG(CONVERT(int , JG )) from [price].[dbo].[v_Price] where PM=@PM and GG=@GG and CZ=@CZ and CD=@CD and DT=@DT

select  @pri2=AVG(CONVERT(float , JG )) from [price].[dbo].[v_Price] where PM=@PM and GG=@GG and CZ=@CZ and CD=@CD and DATEDIFF(MM, CONVERT(datetime, @DT, 120 ),DT)=1

select  @pri3=AVG(CONVERT(float , JG )) from [price].[dbo].[v_Price] where PM=@PM and GG=@GG and CZ=@CZ and CD=@CD and DATEDIFF(MM, CONVERT(datetime, @DT, 120 ),DT)=2

select  @pri4=AVG(CONVERT(float , JG )) from [price].[dbo].[v_Price] where PM=@PM and GG=@GG and CZ=@CZ and CD=@CD and DATEDIFF(MM, CONVERT(datetime, @DT, 120 ),DT)=3



if @pri1>=@pri2 set @price=@pri2 else set @price=@pri1

if @pri3<=@price set @price=@pri3

if @pri4<=@price set @price=@pri4



select @price as RE





END