Hi Dave Ballantyne
Thank you for your answer but i would like know that CTE can be used to update random columns. because when i execute the following statement, i get 100 rows in random. Can i use CTE to update 100 fields in different columns. For example column, i update 10 fields and in column two i update 25 and so on till 100 fields have been changed.
select top 100 from
Table_A
order by newid ()
Thanks a lot
🙁