ALTER PROCEDURE [dbo].[AddBbsTitle]
(@UserId uniqueidentifier,
@UserName nvarchar(256),
@Cid int,
@Title nvarchar(500),
@TitleColour nvarchar(50),
@Content ntext,
@IsTitle bit
)
AS
declare @TitleId int //这里注意
INSERT INTO BbsTitle
(UserId, UserName, CategoryId, Title, TitleColour, Body, AnswerUserId, AnswerUserName)
VALUES
(@UserId, @UserName, @Cid, @Title, @TitleColour, @Content, @UserId, @UserName)
select @TitleId=@@Identity //这里注意
insert into BbsContent
(UserId, UserName, Title, Body, TitleId, CategoryId )
values
(@UserId, @UserName, @Title, @Content, @TitleId, @Cid)
(@UserId uniqueidentifier,
@UserName nvarchar(256),
@Cid int,
@Title nvarchar(500),
@TitleColour nvarchar(50),
@Content ntext,
@IsTitle bit
)
AS
declare @TitleId int //这里注意
INSERT INTO BbsTitle
(UserId, UserName, CategoryId, Title, TitleColour, Body, AnswerUserId, AnswerUserName)
VALUES
(@UserId, @UserName, @Cid, @Title, @TitleColour, @Content, @UserId, @UserName)
select @TitleId=@@Identity //这里注意
insert into BbsContent
(UserId, UserName, Title, Body, TitleId, CategoryId )
values
(@UserId, @UserName, @Title, @Content, @TitleId, @Cid)