SQL存储过程 - MS-SQL Server / BI

我建了两个表，想做个存储过程，当数据插入B表时，B表的RuleID要与A表的ID一样~~~

就是一二级菜单的那种表，二级菜单的RuleID要与一级菜单的ID关联

那个存储过程怎么写？

我的代码如下
SQL code:
create proc insert_B
@BBID int,
@BName nchar(10)
as
select A_ID from A_Menu where A_ID=@BBID
insert into B_Menu
(B_BID,B_Name)
values(@BBID,@BName)

---

SQL code:
create proc insert_B
@BBID int,
@BName nchar(10)
as
begin
if exists(select 1 from A_Menu where A_ID=@BBID)
begin
insert into B_Menu(B_BID,B_Name)values(@BBID,@BName)
end
end

---

SQL code:
create proc insert_B
@BBID int,
@BName nchar(10)
as
begin
if exists(select 1 from A_Menu where A_ID=@BBID)
begin
insert into B_Menu(B_BID,B_Name)values(@BBID,@BName)
end
end

---

学习一下...

---

SQL code:
create proc insert_B
@BBID int,
@BName nchar(10)
as
begin
if exists(select 1 from A_Menu where A_ID=@BBID)
insert into B_Menu(B_BID,B_Name)values(@BBID,@BName)
--加个错误处理
else print 'B表中@BBID