在这个tsql查询中有更多的事情要做吗?

Question

我编写了这个tsql查询，它是一个提供产品代码作为输入的SP，计算并在屏幕上打印应用于所售产品的折扣的平均值。我能做些什么来自动化(如果可能的话)给出的@productid值?我可以在代码中做什么不同的事情?db是Northwind

CREATE PROCEDURE dbo.StoredProcedureMean
AS
BEGIN
DECLARE @productid INT = 26
SELECT avg(Discount) FROM ProductDiscounted WHERE ProductID=@productid   
END 
or
ALTER PROCEDURE dbo.StoredProcedureMean
AS
BEGIN
DECLARE @productid INT = 26
SELECT avg(Discount) FROM ProductDiscounted WHERE ProductID=@productid   
END 

Answer 1

ALTER PROCEDURE dbo.StoredProcedureMean
AS
BEGIN
Declare @Discount_mean FLOAT,
@productid int,
@Name varchar(40)
SELECT @Discount_mean = avg(discount), @productid=ProductID, @Name=productname FROM ProductDiscounted WHERE ProductID=55 GROUP BY productid, Productname
PRINT 'The average value of the discount applied to the product '+ cast(@Name as varchar(40)) + ' with ID ' + cast(@productid as varchar(40)) + ',in the sold, is: ' + cast(@Discount_mean as varchar(40))
END 

所以，这就是我现在所做的，如果有什么不同的我可以做的，有人回答我。