各位好， 我不確定我所命名的主題是否符合Delphi的問題，因為我要用這個預存儲程序在Delphi中，找不到更好的專區發問，請見諒! 下面是我的預存儲程序中的代碼，請看，紅色部份，我是想用個變量傳遞從pcs1--------pcs12之間的名稱 CREATE PROCEDURE dbo.AMRP300 @A1 VARCHAR(4) AS --本期銷貨 if object_id(N'tempdb..##k_pp4') is not null drop table DBO.##k_pp4  CREATE TABLE ##K_pp4 ([pp01] [varchar] (50),[pp02] [varchar] (255),[pp03] [varchar] (20), [pp04] [varchar] (50),[pp05] [varchar] (50),[pp06] [varchar] (50),[pp07] [varchar] (50), [pcs1] [float] (8),[pcs2] [float] (8), [pcs3] [float] (8)，[pcs4] [float] (8), [pcs5] [float] (8),[pcs6] [float] (8),[pcs7] [float] (8), [pcs8] [float] (8),[pcs9] [float] (8), [pcs10] [float] (8),[pcs11] [float] (8), [pcs12] [float] (8),[tpcs] [float] (8) null) on [primary] DECLARE @yy VARCHAR(2) set @yy='01' while @yy<=12 begin INSERT INTO ##K_PP4(PP03,pcs1用變量) SELECT TE04,SUM(dbo.CurrQty(TE04,TE07,TE05)) AS TE07 FROM COPtd,copte WHERE td01=te01 and td02=te02 AND LEFT(TD03,4)=@a1 @yy AND TE17='Y' AND NOT TE01 LIKE 'SY%' and TE06<>'M2' GROUP BY TE04 UNION ALL SELECT TG04,SUM(-dbo.CurrQty(TG04,TG07,TG05)) TG07 FROM COPtf,coptg WHERE tf01=tg01 and tf02=tg02 AND LEFT(TF03,4)=@a1 @yy AND TG18='Y' and TG06<>'M2' GROUP BY TG04 IF CAST(@yy AS FLOAT)<9 SET @yy='0' CAST(CAST(@yy AS FLOAT) 1 AS VARCHAR) else set @yy=CAST(CAST(@yy AS FLOAT) 1 AS VARCHAR) end; 謝謝!!!!!!!!!!!!!!!!!!!!