Using Sp_executesql In Cursor

hi,

I try to use a sql statmenttext as varaible in cursor function with sp_executesql or sp_execsql.

But these Stored Procedures can't use in cursor function.


Q : How can I use a sql statmenttext in corsur funtion as using sp_executesql or sp_execsql ?

Sample Code :


declare @sql nvarchar(500)

declare @table nvarchar(50)

declare @Field1 nvarchar(50)

declare @Field2 nvarchar(50)

declare @FieldValue nvarchar(50)

set @table = 'dbo.kisi_bilgileri'

set @Field1 = 'TcKimlikNo'

set @Field2 = 'KisiNo1'

set @Fieldvalue = '9000050715'

set @sql = 'select ' +@Field1+ ', ' + @Field2+ ' from ' +@table + ' where ' +@Field1+ ' = ' +@Fieldvalue



declare TabloOku cursor for


execute sp_sqlexec @sql -- isn't work, what can I use instead of ?



open TabloOku

fetch next from TabloOku into @Tablo

WHILE @@FETCH_STATUS = 0

begin ...