试试 ALTER PROCEDURE dbo.StoredProcedure3 (@content text, @PageID int OUTPUT) AS INSERT INTO test (Text) VALUES (@content) select @pageid=@@identity RETURN
ALTER TABLE [dbo].[Categorys] ADD CONSTRAINT [FK_Categorys_Categorys] FOREIGN KEY ( [ParentCategory] ) REFERENCES [dbo].[Categorys] ( [Category] ) ON UPDATE NO ACTION, CONSTRAINT [FK_Categorys_Categorys1] FOREIGN KEY ( [ChildCategory] ) REFERENCES [dbo].[Categorys] ( [Category] ) ON UPDATE NO ACTION GO
发错了ALTER PROCEDURE dbo.StoredProcedure3 (@content text, @PageID int OUTPUT) AS begin tran INSERT test (Text) VALUES (@content) set @pageid=@@identity commit tran
ALTER PROCEDURE dbo.StoredProcedure3
(@content text, @PageID int OUTPUT)
AS
INSERT INTO test
(Text)
VALUES (@content)
select @pageid=@@identity RETURN
ALTER TABLE [dbo].[Categorys] ADD
CONSTRAINT [FK_Categorys_Categorys] FOREIGN KEY
(
[ParentCategory]
) REFERENCES [dbo].[Categorys] (
[Category]
) ON UPDATE NO ACTION,
CONSTRAINT [FK_Categorys_Categorys1] FOREIGN KEY
(
[ChildCategory]
) REFERENCES [dbo].[Categorys] (
[Category]
) ON UPDATE NO ACTION
GO
(@content text, @PageID int OUTPUT)
AS
begin tran
INSERT test (Text) VALUES (@content)
set @pageid=@@identity
commit tran