hi can some one help me pls ive written a peice of code to update.. using dynamic sql but it wont update ... does ne one know why example code is...
declare @sql nvarchar(2345)
set @sql = 'declare @i int'
+ ' while @i < 10'
+ ' begin'
+ ' update dupes set checked = 69 where col001 = ''{BFB0454B-BB66-4AA6-B183-0D9F8B9743F6}'''
+ ' set @i = @i + 1'
+ ' end'
exec sp_executesql @sql
declare @sql nvarchar(2345)
set @sql = 'declare @i int'
+ ' while @i < 10'
+ ' begin'
+ ' update dupes set checked = 69 where col001 = ''{BFB0454B-BB66-4AA6-B183-0D9F8B9743F6}'''
+ ' set @i = @i + 1'
+ ' end'
exec sp_executesql @sql