1
Answer

what rowcount means

Ramco Ramco

Ramco Ramco
Aug 19
249
1

Hi

 In below Stored Procedure what @@rowcount means

Create PROCEDURE [dbo].[sp_Department]
    @Action VARCHAR(1)
    ,@EntryNo int = Null
    ,@Description VARCHAR(50) = NULL
    ,@ShortName VARCHAR(25) = NULL
    ,@Success BIT OUTPUT
AS
BEGIN
    SET NOCOUNT ON;

    --INSERT
    IF @Action = 'I'
    BEGIN
        INSERT INTO dbo.Department(Description, createdon, updatedon)
        VALUES (@Description, GETDATE(), GETDATE())
        SET @Success = 1
    END

    --DELETE
    IF @Action = 'D'
    BEGIN
        UPDATE dbo.Department
        SET status = 0, updatedon = GETDATE() WHERE docentry = @EntryNo
        SET @Success = 1
    END

    IF @@ROWCOUNT = 0
        SET @Success = 0
END

Thanks

Answers (1)
Next Recommended Forum