create procedure pro(@name varchar(50),@number int) as declare @flag int; begin select book_name from test where book_name=@name; set @flag = @@rowcount; if @flag>0 update test set number=number+1 where book_name=@name; else insert into test(book_name,number) values(@name,@number); end; execute pro 'PHP',1 写了一个存储过程,能实现你的功能不过不知道时不时你要的结果。
as
declare @flag int;
begin
select book_name from test where book_name=@name;
set @flag = @@rowcount;
if @flag>0
update test set number=number+1 where book_name=@name;
else
insert into test(book_name,number) values(@name,@number);
end;
execute pro 'PHP',1
写了一个存储过程,能实现你的功能不过不知道时不时你要的结果。