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
 SQL Server Administration (2005)
 Random Insertion

Author  Topic 

ratheeshknair
Posting Yak Master

129 Posts

Posted - 2008-06-10 : 05:32:45
Hi Experts ,
I want to insert datas randomly to all columns of a table.The columns have different datatypes like int,varchar,datetime. What to do??? It is urgent so please help.


TIA

RKNAIR

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2008-06-10 : 07:33:12
look at a tool from Reg-Gate.com...datagenerator.
or build your own....using the ORDER BY NEWID() construct or some other methods decribed here under the search topic "Random data"

Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-06-10 : 19:30:36
quote:
Originally posted by ratheeshknair

Hi Experts ,
I want to insert datas randomly to all columns of a table.The columns have different datatypes like int,varchar,datetime. What to do??? It is urgent so please help.


TIA

RKNAIR



Why is it Urgent?
Go to Top of Page
   

- Advertisement -