临时表又出现错误了?
CREATE PROCEDURE prc_fq01 @cEJBH CHAR(3),
@cSJBH CHAR(2),
@cPFKBH CHAR(4),@nf int
AS
BEGIN
CREATE TABLE #fq_01(a1 char(30) ,a2 char(30) ,a3 char(4) ,a4 char(30),a5 char(16),a6 char(20) ,a7 numeric(6, 1) ,
a8 numeric(5, 1) ,a9 char(16),a10 char(16),a11 char(16),a12 char(30),a13 char(16) ,a14 int,a15 numeric(12,4),
a16 numeric(12,4),a17 numeric(6,3),a18 varchar(20),a19 numeric(10,4) ,a20 numeric(6,2) ,a21 numeric(10,4),
a22 numeric(12,4),a23 char(20),a24 int,a25 varchar(50),a26 image,a27 char(4),id int IDENTITY (1, 1) NOT NULL )
insert into #fq_01(a1,a2,a3,a4,a5,a6,a7,a8,a9,a10,a11,a12,a13,a26,a27)
select cSubCompanyName,PFKMC,PFKBH,SZD,KBS, XKZH, TGD,TNJ,PFBZ, PFGL,YWJCK,GYFQLX,ssbh,ktp,havephoto
from vw_fq_01
where onedwbh=@cEJBH and sjbh=@cSJBH and pfkbh=@cPFKBH and nf=@nf
END
GO
sql="exec prc_fq01 '"&x1&"','"&x2&"','"&x3&"' ,"&x4&" "
response.write sql
set rs1 = conn.execute(sql)
sql="select * from #fq_01 "
response.write sql
set rs10 = conn.execute(sql)
提示对象不存在。现在我想问一个问题,我们系统对采用
dim conn
set conn = Server.CreateObject("ADODB.Connection")
conn.Open "driver={SQL Server};server=127.0.0.1;uid=pmis;pwd=hbwrypmis;database=pmis;Persist Security Info=False"
登陆,所以对 sql_server来说只有一个用户,
但是我们系统中又分配了很多注册用户,
在某一个模块中,有报表生成模块,都用到了这个存储过程,用临时表可以满足多个用户吗?我们都是使用uid=pmis;pwd=hbwrypmis;登陆的