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 |
snow12
Yak Posting Veteran
74 Posts |
Posted - 2009-10-14 : 18:45:27
|
I have row number with more than 400 rows. I use select into statement. It only allow 175 rows to get copied into Tem_Table. How to get all rows copied when create new table?select id, code into Tem_table from RMPROP where code = '11'Your help is highly appreciated. |
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-10-14 : 18:47:24
|
remove the where clause ? KH[spoiler]Time is always against us[/spoiler] |
|
|
X002548
Not Just a Number
15586 Posts |
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-10-14 : 19:07:12
|
quote: Originally posted by X002548"I have 3 girlfriends...which one should I keep happy?"
All ?select name from girlfriends randomly ?select top 1 name from girlfriends order by newid() KH[spoiler]Time is always against us[/spoiler] |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-10-15 : 02:32:56
|
quote: Originally posted by snow12 I have row number with more than 400 rows. I use select into statement. It only allow 175 rows to get copied into Tem_Table. How to get all rows copied when create new table?select id, code into Tem_table from RMPROP where code = '11'Your help is highly appreciated.
How many rows does this return?select id, code into Tem_table from RMPROP where code = '11'MadhivananFailing to plan is Planning to fail |
|
|
|
|
|