This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C19EDF.FFEFA2B8
Content-Type: text/plain;
	charset="iso-8859-1"

Another method to return a random record:
http://www.4guysfromrolla.com/webtech/081100-1.shtml

Good asp sites:
http://www.15seconds.com/
http://www.4guysfromrolla.com/
http://www.adopenstatic.com/
http://www.asp101.com/
http://www.aspalliance.com/
http://www.aspfriends.com/
http://www.developersdex.com/asp/
http://www.learnasp.com/aspng/index.aspx
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnasp/html/
asptips.asp


Of these sites most of them have lots of examples, but a couple of them are
a bit different. The link to the MS site gives a list of the top 25 things
you can do to improve the speed of your asp pages. The other slightly
different site is adOpenStatic. This is one of the best ASP sites on the
web. There isn't a huge amount of information there but the information that
is there is *very* good. A lot of other sites will tell you how to do
something, not the best way to do something. Of course MS is always a good
place to look for information on ASP, it is their language.


regards
David Cameron
nOw.b2b
dcameron@i...

-----Original Message-----
From: Zadoyen, Eva [mailto:EZadoyen@s...]
Sent: Thursday, 17 January 2002 3:58 AM
To: sql language
Subject: [sql_language] RE: question about random?


Wesley,
The following tip was published recently:
******************************************************
Random numbers with T-SQL 
The following T-SQL query batch will show you how to generate random numbers
in SQL Server. 
 http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci789852,00.html

You'll find quite a few very helpful SQL tips and links on this site.
Good luck!
	Eva
 

-----Original Message-----
From: Wesley Lorrez [mailto:wesley_lorrez@h...]
Sent: Wednesday, January 16, 2002 12:44 PM
To: sql language
Subject: [sql_language] question about random?


Hi,

I'm just a newbie to SQL and ASP.

Can someone tell me how do I get a random item out off a db, for example, a 
db with 800 questions, how do I get one random question out off it?

Could someone also provide me with good sites about sql and asp?

REgards

Wesley Lorrez
wesley_lorrez@h...


_________________________________________________________________
Download MSN Explorer gratis van http://explorer.msn.nl/intl.asp.


$subst('Email.Unsub').

$subst('Email.Unsub').