Sherzy
3/17/2016 - 4:52 PM

Insert random number

Insert random number

sql_random.sql
content_copyfile_download
UPDATE CompetitionEventStudent
SET random = abs(checksum(NewId()) % 10000)

UPDATE CES
SET random = abs(checksum(NewId()) % 10000)
--select *
FROM [CTS].[dbo].[CompetitionEventStudent] CES
join CTS.dbo.CompetitionEvent CE on CE.[CompetitionEventId] = CES.[CompetitionEventId]
WHERE   (CompetitionId = 65)