select convert(char(6),rand()*1000000),lower(left(newid(),6)) -- 675574 eb55c3
select rand() -- 0.84047079747311859
select newid() -- C9A6FD96-6E25-4239-A5D7-46A2D0F757C2
select convert(char(6),rand()*1000000),lower(left(newid(),6)) -- 675574 eb55c3
select rand() -- 0.84047079747311859
select newid() -- C9A6FD96-6E25-4239-A5D7-46A2D0F757C2