Hello , i have this stored procedure
PROCEDURE [dbo].[MET_Dynamic_Pages_Insert_Tran]
@P_Name nvarchar(50),
@Create_Time nvarchar(100),
@Update_Time nvarchar(100),
@P_Title nvarchar(200),
@P_Contenet nvarchar(max),
@Cat_Id int,
@Is_Active bit,
@Menu_Show bit,
@PageIdSelect int output,
@MenuShow bit output
AS
BEGIN
BEGIN TRY
BEGIN TRAN
DECLARE @PageId int , @StatusId int,@ContentId int
INSERT INTO DynamicPages(P_Name)
VALUES(@P_Name)
Select @PageId=@@IDENTITY
INSERT INTO Status(P_Id,Create_Time,Update_Time)
VALUES(@PageId,@Create_Time,@Update_Time)
SELECT @StatusId=@@IDENTITY
INSERT INTO PagesContent(P_Title,P_Content,P_Id,S_Id)
VALUES(@P_Title,@P_Contenet,@PageId,@StatusId)
Select @ContentId=@@IDENTITY
INSERT INTO DynamicPagesRelation(Dyn_Page_Id,Content_Id,Cat_Id,Status_Id,Is_Active,Menu_Show)
VALUES(@PageId,@ContentId,@Cat_Id,@StatusId,@Is_Active,@Menu_Show)
COMMIT TRAN
END TRY
BEGIN CATCH
ROLLBACK TRAN
PRINT ' THERE WAS AN ERROR '
PRINT ERROR_MESSAGE()
END CATCH
SET @PageIdSelect=(SELECT @PageId FROM DynamicPagesRelation)
SET @MenuShow = (SELECT @Menu_Show FROM DynamicPagesRelation)
END
thes stored work in the first insertion !
but when i push my button again to use this stored its say that !
ERROR : Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.