/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

8 votes139 views2 answers
Oracle auto increment primary key
SQL
0 vote115 views1 answer
Mysql remove last character
SQL
1 vote99 views1 answer
Update from select join
SQL
3 votes107 views2 answers
Postgres show table schema
SQL
1 vote103 views1 answer
Psql search table
SQL
1 vote100 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote109 views1 answer
Virtuoso sql query tutorial
SQL
6 votes99 views3 answers
Update with inner join postgres
SQL
0 vote140 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL
2 votes133 views1 answer
Find column in all stored procedures sql server
SQL