这个存储不能用?急呀!!!!
CREATE PROCEDURE doupcl
@mycllb varchar(50),
@myclmc varchar(50),
@myggxh varchar(50),
@mygydw varchar(50),
@myjldw varchar(50),
@myupdate datetime,
@myje money
AS
declare @mycount int
declare @SqlString nvarchar(1000)
declare @thggxh varchar(50)
declare @thgydw varchar(50)
declare @thjldw varchar(50)
set @thggxh=isnull(@myggxh,"")
set @thgydw=isnull(@mygydw,"")
set @thjldw=isnull(@myjldw,"")
set @mycount=0
if EXISTS(select * from clsj where cllb=@myclmc and clmc=@myclmc and ggxh=@thggxh and gydw=@thgydw and jldw=@thjldw) begin
update clsj
set je = @myje,upyeardate=@myupdate
where cllb=@myclmc and clmc=@myclmc and ggxh=@thggxh and gydw=@thgydw and jldw=@thjldw
end
else begin
insert into clsj(cllb,clmc,ggxh,gydw,jldw,je,upyeardate)
values(@mycllb,@myclmc,@thggxh,@thgydw,@thjldw,@myje,@myupdate)
end
GO
当我输入条件时发现update总是不能执行到!,
谁解决了我还有100分奉送,
http://expert.csdn.net/Expert/topic/1232/1232364.xml?temp=.4891779