select * from namatabel order by newid()
Query generates a random number between 1 and 10.
UPDATE @TT
SET DayAlloted = ABS(CHECKSUM(NEWID())) % 100 + 24
generate top 10 random field
SELECT TOP 10 RAND() AS [RandomNumber], [CustomerID], [CompanyName], [ContactName]
FROM [dbo].[Customers]
No comments:
Post a Comment