Hi
I have below code . It returns success = false though record is inserted.When i comment below 2 lines then it works o.k
IF @@ROWCOUNT = 0
SET @Success = 0
ALTER PROCEDURE [dbo].[sp_Department]
@Action VARCHAR(1)
,@DocEntryNo int = Null
,@Description VARCHAR(50) = NULL
,@ShortName VARCHAR(15) = NULL
,@Status bit = NULL
,@Success BIT OUTPUT
AS
BEGIN
SET NOCOUNT ON;
--INSERT
IF @Action = 'I'
BEGIN
INSERT INTO dbo.Department(Description,ShortName,status,createdby,createdon,updatedby,updatedon)
VALUES (@Description,@ShortName,1,1,GETDATE(),1,GETDATE())
SET @Success = 1
END
--DELETE
IF @Action = 'D'
BEGIN
UPDATE dbo.Department
SET status = 0 , updatedon = GETDATE(),updatedby = 1 WHERE docentry = @DocEntryNo
SET @Success = 1
END
IF @@ROWCOUNT = 0
SET @Success = 0
END
Thanks