Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Using the RAND() function

Author  Topic 

KyBrBe
Starting Member

1 Post

Posted - 2004-12-01 : 08:00:00
I am taking an SQL class and our professor wants us to use the RAND() function to populate tables. I seem to be having a very difficult time getting the syntax right to actually get the data into the table I've created - especially if there are specific criteria for the fields, i.e. within a certain range of numbers or with incremental increases.

Could anyone refer me to some type of reference that would have more information on this particular area? I'm finding it difficult to locate good references for SQL - especially Transact-SQL.

Thanks!

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2004-12-01 : 08:14:24
well this place is great. for a solution we'd need you to tell us what exactly you need to do...
http://www.sqlteam.com/store.asp
http://www.sqlteam.com/filtertopics.asp?TopicID=168

Go with the flow & have fun! Else fight the flow
Go to Top of Page

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2004-12-01 : 08:19:17
Do you have access to BOL ? which is the documentation for SQL Server, has lots of T-SQL stuff.
Get it from
microsoft

rockmoose
Go to Top of Page

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2004-12-01 : 09:48:55
* warning: shameless plug *

also consider checking this out:

http://weblogs.sqlteam.com/jeffs/archive/2004/11/22/2927.aspx

since the RAND() function may not work the way you expect in a SELECT statement.

* end of warning *

- Jeff
Go to Top of Page
   

- Advertisement -