Hi everybody,

I'd like to update some records in my table. I don't have any criteria to update, so it should be some random number of records.

Do you know how can I do this in SQL Server?

I used

update Schools set SchoolPhone = '718-805-9999' where school in (select top 20 school from Schools order by School) but this is not random.

Thanks a lot in advance.

UPDATE. Found my answer already.