create procedure testproc (@name varchar(20),@adress varchar(20)) as
insert table1 (name) values (@name)
declare @id int;
select @id=id from table1 where name=@name
insert table2 (adress) values (@adress)return这样可以吗?
insert table1 (name) values (@name)
declare @id int;
select @id=id from table1 where name=@name
insert table2 (adress) values (@adress)return这样可以吗?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货