我有一张桌子
并与最终结果相乘,结果如下:
一个过程定义如下乘法:(它必须将下拉列表的值与数据库中的值相乘,然后水平求和,并在最终结果中显示结果。
CREATE PROCEDURE [dbo].[Cstored]
AS
BEGIN
SET NOCOUNT ON;
DECLARE @Ta int
DECLARE @Em int
DECLARE @Ma int
DECLARE @Sa int
SET @Em = 8 >>>> need to be set by user selection in dropdows list