/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 vote168 views1 answer
Sql server bool select
SQL
0 vote184 views1 answer
Psotgres multiple values
SQL
0 vote193 views1 answer
Mysql check datetime equals date
SQL
1 vote196 views1 answer
Add current timestamp in mysql
SQL
24 votes180 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
SQL
1 vote196 views1 answer
Sql server get users
SQL
8 votes187 views1 answer
How to check mysql version in xampp
SQL
5 votes178 views1 answer
Oracle nls session
SQL
1 vote185 views1 answer
Postgres start database on linux
SQL
0 vote184 views1 answer
Min salary in sql
SQL