create procedure addtopic@userId int,
@createTime datatime,
@count int,
@keywordText nvarchar(254)
as
declare @keywordid int
select @keywordid=keywordID from keyword where keywordtext = @keywordTextif @@rowcount<0
begin
insert into keyword keywordtext=@keywordText,select @keywordid = keywordid from keyword where keywordtext = @keywordText insert into topic (userid,createtime,visitcount,keywordid)
values (@userid,@createtime,1,@keywordid)
end
@createTime datatime,
@count int,
@keywordText nvarchar(254)
as
declare @keywordid int
select @keywordid=keywordID from keyword where keywordtext = @keywordTextif @@rowcount<0
begin
insert into keyword keywordtext=@keywordText,select @keywordid = keywordid from keyword where keywordtext = @keywordText insert into topic (userid,createtime,visitcount,keywordid)
values (@userid,@createtime,1,@keywordid)
end
@createTime datatime,
@count int,
@keywordText nvarchar(254)
as
declare @keywordid int
select @keywordid=keywordID from keyword where keywordtext = @keywordTextif @@rowcount<=0
begin
insert into keyword keywordtext=@keywordText,select @keywordid = keywordid from keyword where keywordtext = @keywordText insert into topic (userid,createtime,visitcount,keywordid)
values (@userid,@createtime,1,@keywordid)
end
To wukele(猪): end 要放前面,@@rowcount>0时,也要进行下面的select和insert操作..
你看对不??