subject_14718.htm

一些关于vc的问答

<p>
序号：14718 发表者：judy 发表日期：2002-09-10 19:19:30
<br>主题：我想請問一下Rand()函數在Select子句中能用嗎？
<br>内容：最近我看了一個關於對於"如何對查詢結果進行隨機排序？"，他說可以使用Rand()函數實現，但沒有舉例，恕我愚昧，我不明白它的用法！想請教各位幫個忙！
<br><a href="javascript:history.go(-1)">返回上页</a><br><a href=http://www.copathway.com/cndevforum/>访问论坛</a></p>
<hr size=1>
<blockquote><p>
回复者：林彬 回复日期：2002-09-11 11:48:23
<br>内容：看看SQL的书就OK了，<BR>这是很基本的东西。<BR>
<br>
<a href="javascript:history.go(-1)">返回上页</a><br><a href=http://www.copathway.com/cndevforum/>访问论坛</a></p></blockquote>
<hr size=1>
<blockquote><p>
<font color=red>答案被接受</font><br>回复者：david (小鱼儿) 回复日期：2002-09-11 11:50:16
<br>内容：RAND (T-SQL)<BR>Returns a random float value between 0 and 1.<BR><BR>Syntax<BR>RAND([seed])<BR><BR>Arguments<BR>seed <BR>Is an integer expression (tinyint, smallint, or int) giving the seed or starting value. <BR>Return Types<BR>float<BR><BR>Examples<BR>This example uses a variable to produce five different random numbers generated with the RAND function.<BR><BR>DECLARE @counter smallint<BR><BR>SET @counter = 1<BR><BR>WHILE @counter &lt; 5<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;BEGIN<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SELECT RAND(@counter)<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SET NOCOUNT ON<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SET @counter = @counter + 1<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SET NOCOUNT OFF<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;END<BR><BR>GO<BR><BR>&nbsp;&nbsp;<BR><BR>Here is the result set:<BR><BR>(1 row(s) affected)<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR><BR>------------------------ <BR><BR>0.00125125888851588&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR><BR>(1 row(s) affected)<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR><BR>------------------------ <BR><BR>0.00137333292641987&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR><BR>(1 row(s) affected)<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR><BR>------------------------ <BR><BR>0.00146488845484787&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR><BR>(1 row(s) affected)<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR><BR>------------------------ <BR><BR>0.00155644398327586&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR><BR>(1 row(s) affected)<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR>
<br>
<a href="javascript:history.go(-1)">返回上页</a><br><a href=http://www.copathway.com/cndevforum/>访问论坛</a></p></blockquote>
<hr size=1>
<blockquote><p>
回复者：judy 回复日期：2002-09-11 18:27:36
<br>内容：明白了，謝謝！
<br>
<a href="javascript:history.go(-1)">返回上页</a><br><a href=http://www.copathway.com/cndevforum/>访问论坛</a></p></blockquote>