Query statements in SQL Server cursors use variable issues

DECLARE @TableName VARCHAR (32); --Data table name

DECLARE @DateCounter VARCHAR (32); --Time and date

DECLARE @ID

--Creating cursors

The statements after--exec need to be character types, so @tablename and @datecounter variables are character types

EXEC (' DECLARE mycursor CURSOR for SELECT ID from ' [Email protected]+ ' WHERE convert (VARCHAR (), datetime,120) = CONVERT (VA Rchar (Ten), ' [email protected]+ ', 120] ')

OPEN MyCursor

FETCH NEXT from MyCursor to @ID

While @ @FETCH_STATUS =0

BEGIN

--Business processing

　　

FETCH NEXT from MyCursor to @ID

END

CLOSE MyCursor

Deallocate mycursor

--Cursor End

Query statements in SQL Server cursors use variable issues