建立在gkrogers哈希建议的基础上，效果很好。对性能有什么想法吗？
declare @seed as int;set @seed = 10;create table temp (id int,date datetime)insert into temp (id, date) values (1,'20090119')insert into temp (id, date) values (2,'20090118')insert into temp (id, date) values (3,'20090117')insert into temp (id, date) values (4,'20090116')insert into temp (id, date) values (5,'20090115')insert into temp (id, date) values (6,'20090114')-- re-seeds for every itemselect *, HASHBYTES('md5',cast(id+@seed as varchar)) rfrom temp order by r--1 2009-01-19 00:00:00.000 0x6512BD43D9CAA6E02C990B0A82652DCA--5 2009-01-15 00:00:00.000 0x9BF31C7FF062936A96D3C8BD1F8F2FF3--4 2009-01-16 00:00:00.000 0xAAB3238922BCC25A6F606EB525FFDC56--2 2009-01-18 00:00:00.000 0xC20AD4D76FE97759AA27A0C99BFF6710--3 2009-01-17 00:00:00.000 0xC51CE410C124A10E0DB5E4B97FC2AF39--6 2009-01-14 00:00:00.000 0xC74D97B01EAE257E44AA9D5BADE97BAFdrop table temp编辑：请注意，如果使用动态SQL，则@seed在查询中的声明可以用参数或常量int代替。（不必以TSQL方式声明@int）
