set nocount on
go
declare @i int
set @i = 0
while (@i < 8)
begin
    select rand((datepart(mm, getdate()) * 100000) + (datepart(ss, getdate()) * 1000) +
                (datepart(ms, getdate()) * @i)),
        rand(convert(int, convert(varbinary, newid())))
    set @i = @i + 1
end

This page was last updated on May 01, 2006 04:28 PM.