You can count the rows before and after or use @@ROWCOUNT

😎

USE tempdb;

GO

DECLARE @PRECOUNT INT = 0;

DECLARE @RET_VAL INT =0;

DECLARE @TABLEX TABLE (IVAL INT NOT NULL);

SELECT @PRECOUNT = COUNT(*) FROM @TABLEX

INSERT INTO @TABLEX (IVAL) VALUES (1),(1);

SELECT @RET_VAL = SIGN ((SELECT COUNT(*) FROM @TABLEX) - @PRECOUNT)

SELECT @RET_VAL

INSERT INTO @TABLEX (IVAL) VALUES (1),(1),(1);

SELECT @RET_VAL = SIGN(@@ROWCOUNT);

SELECT @RET_VAL;