MSSQL Using a dynamic cursor

Use Pubs
Declare @tblName Varchar(40)
Declare @SQL varchar(2000)

Set @tblName = 'Authors'
SET @SQL = 'DECLARE Dyn_cursor CURSORFOR SELECT * FROM ' + @tblName

Exec(@SQL)

Open Dyn_Cursor


Close Dyn_cursor

Deallocate Dyn_cursor

Till Next Time