阿斯顿马丁发布按钮的功能

--发布消息按钮
create proc dbo.usp_PublishMessageUpdateUserId
(
    @messageId int
)
as
begin transaction
delete from MessageToUser where MessageId=@messageId
insert into MessageToUser(MessageId,ToUserId,IfRead) values(@messageId,'0',0)
if(@@error<>0)
begin
rollback transaction
end
else
begin
commit transaction
end




exec usp_PublishMessageUpdateUserId 14