/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 vote274 views1 answer
Oracle split string
SQL
0 vote262 views1 answer
Alter precision
SQL
17 votes292 views4 answers
Mysql remove ubuntu
SQL
0 vote314 views2 answers
How to drop mili second in sql
SQL
6 votes275 views2 answers
Join vs union
SQL
0 vote369 views1 answer
Compare strings lexicographically in sql
SQL
0 vote339 views2 answers
Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Your result cannot contain duplicates.
SQL
25 votes350 views5 answers
Mysql replace text
SQL
0 vote276 views1 answer
Postgresql not in alternative
SQL
1 vote288 views1 answer
How to delete data from sql database in android
SQL