<div>
<a href="http://dev.mysql.com/doc/mysql/en/index.html" rel="ugc">http://dev.mysql.com/doc/mysql/en/index.html</a><br />
<br />
You need to use ROUND(X) , ROUND(X,D) <br />
<br />
<br />
FtB<br />

</div>


http://dev.mysql.com/doc/mysql/en/index.html [http://dev.mysql.com/doc/mysql/en/index.html]

You need to use ROUND(X) , ROUND(X,D)


FtB


<div>
Unless you want random, which is:<br />
<br />
RAND() , RAND(N) &lt;--N is the seed<br />
<br />
FtB
</div>


Unless you want random, which is:

RAND() , RAND(N) <--N is the seed

FtB

<div>
<div class="content wysiwyg-content">
I am converting this code from Access to MSSQL,<br />
<br />
I have an error that reads:<br />
<br />
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)<br />
[Microsoft][ODBC SQL Server Driver][SQL Server]'rnd' is not a recognized function name.<br />
<br />
The code says:<br />
<br />
Randomize <br />
R=clng(1E6*rnd)<br />
strSQL = &quot;SELECT * FROM [feedback] WHERE feedbackstatus = 'show' ORDER BY rnd(-(1000*dc_feedbackKey)<wbr />* &quot;&nbsp;&amp; R &amp;&nbsp;&quot;)&quot;<br />
<br />
It randomizes the set of records.<br />
Anyone know how to write this out for MSSQL?<br />
<br />
Also is there an online reference for comparrissons between Access, MSSQL, and MYSQL for ASP code?<br />
<br />
Thx
</div>
</div>


I am converting this code from Access to MSSQL,

I have an error that reads:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]'rnd' is not a recognized function name.

The code says:

Randomize 
R=clng(1E6*rnd)
strSQL = "SELECT * FROM [feedback] WHERE feedbackstatus = 'show' ORDER BY rnd(-(1000*dc_feedbackKey)* " & R & ")"

It randomizes the set of records.
Anyone know how to write this out for MSSQL?

Also is there an online reference for comparrissons between Access, MSSQL, and MYSQL for ASP code?

Thx

Converting from Access to MSSQL - rnd function

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.