SQLBUG集之"随机排序中的newid()问题"

<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

/**==**2. 随机排序中的 newid() 问题**==**/--测试数据declare@ttable(namechar(1),valueint)insertinto@tselect'a',1unionallselect'a',2unionallselect'b',3unionallselect'b',4unionallselect'c',5unionallselect'c',6

--要求,随机排序,但name相同的要排在一齐selecta.*from@tajoin( selectaa= newid(),namefrom(selectdistinctnamefrom@t)a)bona.name=b.nameorderbyb.aa, newid()

/*--测试结果之一,并没有达到要求.如果将join改成leftrightfulljoin,就正确namevalue      ---------------b   4b   3c   5a   1a   2c   6

（所影响的行数为6行）--*/

<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>