Home about IT Motivation Course Sales Project About Me

Sunday, May 16, 2010

random in SQL server database

below script to random all row number:
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: