我在sql server 2000中创建存储过程时,提示对象名无效,为什么呀?
语法是没有错误的
代码如下
ALTER PROCEDURE spAddPar
@prdid int,
@supid int,
@purdat samlldatetime,
@puremp varchar(10),
@purqua smallint,
@purprc smallmoney,
@purmemo varchar(10)
As
declare @orgprdqua int
select @orgprdqua=prdqua from productlist where prdid=@prdid
insert into purchaseproduct(prdid,supid,purdat,puremp,purqua,parprc,purmemo)values(@prdid,@supid,@purdat,@puremp,@purqua,@purprc,@purmemo)
update productlist set prdqua=@orgprdqua+@purqua
where prdid=@prdid
RETURN
语法是没有错误的
代码如下
ALTER PROCEDURE spAddPar
@prdid int,
@supid int,
@purdat samlldatetime,
@puremp varchar(10),
@purqua smallint,
@purprc smallmoney,
@purmemo varchar(10)
As
declare @orgprdqua int
select @orgprdqua=prdqua from productlist where prdid=@prdid
insert into purchaseproduct(prdid,supid,purdat,puremp,purqua,parprc,purmemo)values(@prdid,@supid,@purdat,@puremp,@purqua,@purprc,@purmemo)
update productlist set prdqua=@orgprdqua+@purqua
where prdid=@prdid
RETURN
@prdid int,
@supid int,
@purdat datetime,
@puremp varchar(10),
@purqua smallint,
@purprc smallmoney,
@purmemo varchar(10)
As
declare @orgprdqua int select @orgprdqua=prdqua from productlist where prdid=@prdid insert into purchaseproduct(prdid,supid,purdat,puremp,purqua,parprc,purmemo)
values(@prdid,@supid,@purdat,@puremp,@purqua,@purprc,@purmemo) update productlist set prdqua=@orgprdqua+@purqua
where prdid=@prdidRETURN
@prdid int,
@supid int,
@purdat samlldatetime, --- 这个地方拼写错了 smalldatetime 或者 datetime
@puremp varchar(10),
@purqua smallint,
@purprc smallmoney,
@purmemo varchar(10)
As
declare @orgprdqua int
select @orgprdqua=prdqua from productlist where prdid=@prdid
insert into purchaseproduct(prdid,supid,purdat,puremp,purqua,parprc,purmemo)values(@prdid,@supid,@purdat,@puremp,@purqua,@purprc,@purmemo)
update productlist set prdqua=@orgprdqua+@purqua
where prdid=@prdid
RETURN