/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 vote389 views1 answer
Login failed for user sql server
SQL
14 votes365 views4 answers
Remove record from table sql
SQL
37 votes551 views3 answers
Sql check duplicate value in column
SQL
11 votes383 views3 answers
Pl sql example
SQL
8 votes355 views3 answers
Alter table auto_increment
SQL
1 vote356 views1 answer
Sample in sql
SQL
0 vote397 views1 answer
Python sqlalchemy connection show server
SQL
0 vote360 views1 answer
How to print mysql query of codeigniter query builder
SQL
10 votes356 views1 answer
Oracle all_dependencies
SQL
1 vote365 views1 answer
CREATE DATABASE db; SyntaxError: Unexpected identifier
SQL