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 2005 Forums
 Transact-SQL (2005)
 Random numbers

Author  Topic 

collie
Constraint Violating Yak Guru

400 Posts

Posted - 2008-03-19 : 03:47:46
Hi,

I have an int column that i want to have random numbers inserted into it.
How can I create random integer numbers to insert into my column?

Thanks

Whisky-my beloved dog who died suddenly on the 29/06/06-I miss u so much.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-03-19 : 05:20:08
http://sqlblogcasts.com/blogs/madhivanan/archive/2007/08/27/generate-random-numbers.aspx
Go to Top of Page

ranganath
Posting Yak Master

209 Posts

Posted - 2008-03-19 : 05:25:13
http://blog.sqlauthority.com/2007/04/29/sql-server-random-number-generator-script-sql-query/
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2008-03-19 : 10:55:36
You can use the Random Integer function, F_RANDOM_INTEGER, on this link.

Random Integer, Sample, and Datetime Functions
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=69499



CODO ERGO SUM
Go to Top of Page
   

- Advertisement -