SQL Server
Returns the number of rows affected by the last statement. (@@ROWCOUNT in Transact-SQL).
@@ROWCOUNT
Snowflake SQL Documentation
SQLROWCOUNT
Code:
CREATE TABLE table1 ( column1 INT ); CREATE PROCEDURE procedure1 AS BEGIN declare @addCount int = 0; INSERT INTO table1 (column1) VALUES (1),(2),(3); set @addCount = @addCount + @@ROWCOUNT select @addCount END ; GO EXEC procedure1;
Result:
+-+ | | +-+ |3| +-+
CREATE OR REPLACE TABLE table1 ( column1 INT ) COMMENT = '{ "origin": "sf_sc", "name": "snowconvert", "version": { "major": 0, "minor": 0, "patch": "0" }, "attributes": { "component": "transact", "convertedOn": "11/13/2024", "domain": "test" }}' ; CREATE OR REPLACE PROCEDURE procedure1 () RETURNS TABLE() LANGUAGE SQL COMMENT = '{ "origin": "sf_sc", "name": "snowconvert", "version": { "major": 0, "minor": 0, "patch": "0" }, "attributes": { "component": "transact", "convertedOn": "11/13/2024", "domain": "test" }}' EXECUTE AS CALLER AS $$ DECLARE ADDCOUNT INT := 0; ProcedureResultSet RESULTSET; BEGIN INSERT INTO table1 (column1) VALUES (1),(2),(3); ADDCOUNT := :ADDCOUNT + SQLROWCOUNT; ProcedureResultSet := ( select :ADDCOUNT); RETURN TABLE(ProcedureResultSet); END; $$; CALL procedure1();
+----------+ |:ADDCOUNT | +----------+ | 3 | +----------+
No issues were found.
No related EWIs.
Last updated 23 days ago