GO
CREATE PROCEDURE dbo.sp_mysp
(
@RoleID int,
@AcessRights varchar(50),
@Name varchar(100),
@IsActive bit,
@IsDeleted bit,
@CreatedBy int,
@ModifiedBy int
)
AS
BEGIN
BEGIN TRANSACTION;
SAVE TRANSACTION MySavePoint;
BEGIN TRY
insert into UserLogin
(
[RoleID] ,
[AccessRights] ,
[Name],
[IsActive] ,
[IsDeleted] ,
[CreatedBy] ,
[CreatedDate],
[ModifiedBy] ,
[ModifiedDate]
)
values(
@RoleID ,
@AcessRights ,
@Name,
@IsActive ,
@IsDeleted ,
@CreatedBy ,
getdate() ,
@ModifiedBy ,
getdate()
);
//Write Table second Insert Query
END TRY
BEGIN CATCH
IF @@TRANCOUNT > 0
BEGIN
ROLLBACK TRANSACTION MySavePoint; -- rollback to MySavePoint
END
END CATCH
COMMIT TRANSACTION
END;
GO
No comments:
Post a Comment
Thank You For Your Great Contribution