create procdure proc_insUserInfo
(@userid varchar(100),
@userpwd varchar(100),
@info1 varchar(100),
@info2 varchar(100),
@info3 varchar(100))
as
begin
insert into table1(userid,userpwd) values(@userid,@userpwd)
insert into table2(userid,info1,info2,info3) values(@userid,@info1,@info2,@info3)
end
create procdure proc_insUserInfo
(@userid varchar(100),
@userpwd varchar(100),
@info1 varchar(100),
@info2 varchar(100),
@info3 varchar(100))
as
begin
insert into table1(userid,userpwd) values(@userid,@userpwd)
insert into table2(userid,info1,info2,info3) values(@userid,@info1,@info2,@info3)
end
第二张表是用户其他信息,它还有一个字段的外键约束为第一张表的ID create procdure proc_insUserInfo (
@username varchar(100),
@userpwd varchar(100),
@info1 varchar(100),
@info2 varchar(100),
@info3 varchar(100)
) as
begin
declare @userid int
insert into table1(username,userpwd) values(@username,@userpwd)
set @userid = @@identity
insert into table2(userid,info1,info2,info3) values(@userid,@info1,@info2,@info3)
end