/SQL/Sql transact create cursor with dynamic tables

Sql transact create cursor with dynamic tables

Declare @UserID varchar(100)
declare @sqlstatement nvarchar(4000)
--move declare cursor into sql to be executed
set @sqlstatement = 'Declare  users_cursor CURSOR FOR SELECT userId FROM users'

exec sp_executesql @sqlstatement


OPEN users_cursor
FETCH NEXT FROM users_cursor
INTO @UserId

WHILE @@FETCH_STATUS = 0
BEGIN
Print @UserID
EXEC asp_DoSomethingStoredProc @UserId

FETCH NEXT FROM users_cursor --have to fetch again within loop
INTO @UserId

END
CLOSE users_cursor
DEALLOCATE users_cursor

Source: stackoverflow.com

Similar codes

0 vote291 views1 answer
Getting next sequence value jpa postgress
SQL
0 vote319 views1 answer
How to define a non primary composite key in sql
SQL
1 vote308 views1 answer
Mysql view command
SQL
0 vote314 views1 answer
Connecting to my cloud sql server with c#
SQL
9 votes286 views4 answers
Mysql show table fields
SQL
1 vote295 views1 answer
Loading local data is disabled mysql
SQL
0 vote308 views1 answer
Inserted row count tsql
SQL
0 vote296 views1 answer
Convert rows into columns in oracle
SQL
0 vote285 views1 answer
Select other columns with distinct
SQL
1 vote324 views1 answer
Code: "ER_TRUNCATED_WRONG_VALUE", errno: 1292, sqlMessage: "Incorrect date value: '2021-03-20T18:30:00.000Z' for column 'mgfdate' at row 1", sqlState: "22007", index: 0, …}
SQL