Create Procedure rj2(@rq Date,@name varchar(20),@address varchar(10))
As
Begin
Declare @T Date
set @T=To
if Exist (Select Time from rj where T=To)
update rj
set notes=@notes
set caution=@caution
else
insert into rj(rq,name,address)into values (:rq,:name,:address)
end
As
Begin
Declare @T Date
set @T=To
if Exist (Select Time from rj where T=To)
update rj
set notes=@notes
set caution=@caution
else
insert into rj(rq,name,address)into values (:rq,:name,:address)
end
insert into rj(rq,name,address)into values (@rq,@name,@address) 吧
set notes=@notes
set caution=@caution
->
update rq set notes=@notes, caution=@caution3. insert into rj(rq,name,address)into values (:rq,:name,:address)
->
insert into rj(rq,[name],address) values (@rq, @name, @address)
存储过程貌似不支持“:”。