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.
Author |
Topic |
ratheeshknair
Posting Yak Master
129 Posts |
Posted - 2008-06-10 : 05:30:37
|
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.TIARKNAIR |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-10 : 05:40:45
|
What data? You just want to insert some random values? |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-06-10 : 07:08:33
|
insert into your_table select '1','2','a','b'gocopy paste for many times and runArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-06-10 : 07:14:45
|
For SQL Server 2005insert your_table values ('1','2','a','b')go 500000 will insert same record 500,000 times E 12°55'05.25"N 56°04'39.16" |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-06-10 : 09:30:49
|
http://sqlserver-qa.net/blogs/t-sql/archive/2008/04/04/3976.aspxMadhivananFailing to plan is Planning to fail |
|
|
ratheeshknair
Posting Yak Master
129 Posts |
Posted - 2008-06-10 : 23:36:26
|
Thankyou ALL :-)RKNAIR |
|
|
|
|
|