我的存储过程在程序不但无法返回记录集,而且...
CREATE PROCEDURE spGetEnterpriseSet
@RegionCode varchar(10)=''
AS
CREATE TABLE #t_tempEnterprise (
[f_index] [int] IDENTITY (1, 1) NOT NULL ,
[f_usercode] [int] NOT NULL ,
[f_areacode] [varchar] (10) NOT NULL ,
[f_findcode] [varchar] (10) NOT NULL ,
[f_code] [varchar] (10) NOT NULL ,
[f_filecode] [varchar] (20) NOT NULL ,
[f_name] [varchar] (50) NOT NULL ,
[f_devicerl] [numeric](18, 4) NOT NULL ,
[f_dydj] [varchar] (10) NOT NULL ,
[f_address] [varchar] (50) NOT NULL ,
[f_tradecode] [varchar] (10) NOT NULL ,
[f_llcos] [numeric](18, 4) NOT NULL ,
[f_jclvcos] [numeric](18, 4) NOT NULL ,
[f_connectman] [varchar] (20) NOT NULL ,
[f_phone] [varchar] (20) NOT NULL ,
[f_bank] [varchar] (20) NOT NULL ,
[f_bankusername] [varchar] (20) NOT NULL ,
[f_account] [varchar] (20) NOT NULL ,
[f_taxcode] [varchar] (20) NOT NULL ,
[f_gyareafl] [int] NOT NULL ,
[f_flag] [int] NOT NULL ,
[f_printflag] [int] NOT NULL ,
[f_supplydate] [smalldatetime] NOT NULL
)
INSERT #t_tempEnterprise
SELECT f_usercode,f_areacode,f_findcode,f_code,f_filecode,f_name,f_devicerl,f_dydj,f_address,f_tradecode,f_llcos,f_jclvcos,f_connectman,f_phone,f_bank,f_bankusername,f_account,f_taxcode,f_gyareafl,f_flag,f_printflag,f_supplydate
--FROM t_chargeuser WHERE f_areacode LIKE @RegionCode+'%' AND f_flag&2=2
FROM t_chargeuser WHERE f_areacode LIKE '01%' AND f_flag&2=2
SELECT * FROM #t_tempEnterprise
DROP TABLE #t_tempEnterprise
上面的存储过程在程序中无法用exec spGetEnterpriseSet 参数打开。
敬请高手分析。