存储过程中涉及多个表多个语句的问题

我的表结构如下：
create table dt_articleclass
(
acid tinyint primary key identity(1,1),
acname varchar(50) not null
)

create table dt_article
(
aid int primary key identity(1,1),
atitle varchar(50) not null,
acontent text not null,
aauthor varchar(30) not null,
acid tinyint not null foreign key references dt_articleclass(acid)
)

create table dt_articlepulish
(
apid int primary key identity(1,1),
aptime datetime not null,
apaccount int default 0,
uid int not null foreign key references dt_user(uid),
aid int not null foreign key references dt_article(aid)
)

要编写存储article的存储过程，因为涉及到三个表，不知该怎样编写存储过程，我编写的如下，但是不可以

create proc addarticle
@acid int,
@title varchar(50),
@content text,
@author varchar(50),
@addtime datetime,
@userid int
as
declare @aid int
insert into dt_article(atitle,acontent,aauthor,acid) values(@title,@content,@author,@acid)
select @aid=max(aid) from dt_article
insert into dt_articlepublish(aptime,uid,aid) values(@addtime,@userid,@aid)
go

请问那里出了问题



[解决办法]
create proc addarticle
@acid int,
@title varchar(50),
@content text,
@author varchar(50),
@addtime datetime,
@userid int
as
begin
declare @aid int
insert into dt_article(atitle,acontent,aauthor,acid) values(@title,@content,@author,@acid)
select @aid=max(aid) from dt_article
insert into dt_articlepublish(aptime,uid,aid) values(@addtime,@userid,@aid)
end
go

[解决办法]
要先dt_articleclass中有对应的acid，才能向dt_article插入，再向dt_articlepublish中插入