/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

1 vote297 views2 answers
Job for mysql.service failed because the control process exited with error code. see "systemctl status mysql.service" and "journalctl -xe" for details.
SQL
1 vote253 views1 answer
Postgres get timestamp
SQL
0 vote270 views1 answer
Empty table sqlite
SQL
0 vote286 views2 answers
.... ERROR! The server quit without updating PID file mysql centos
SQL
0 vote291 views1 answer
Migration graphql
SQL
0 vote287 views1 answer
Python list from sql
SQL
1 vote255 views1 answer
GROUP BY clause; this is incompati
SQL
1 vote269 views1 answer
Full sql mode
SQL
0 vote323 views1 answer
Mysql concatenate select results
SQL
0 vote268 views1 answer
See Foreign Key
SQL