xForum
Titlle
id TitleName UserID UserName PostTime
TieZiDetail
id TitleID PinLunTitle UserName PostTime
IP Content
插入数据 先插入到Title里然后获取帖子的ID
然后把帖子ID获取出来
在插入到TIEZIDETAIL表里
这样就完成了 双表操作
需要参数@TitleName,@UserName,@PostTime,
create procedure FaXinTie
@TitleName varchar(50),
@Content varchar(2000),
@PostTime datetime,
@UserName varchar(50),
@TitleID int output
AS
declare @newid int
insert into Title(TitleName,UserName,PostTime) values(@TitleName,@UserName,@PostTime)
select @newid=max(ID) from Title
insert into TieZiDetail(TitleID,UserName,PostTime,Content) values(@newid,@UserName,@PostTime,@Content)
select @TitleID=@newid