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 |
|
abhijaiswal.84
Starting Member
29 Posts |
 Posted - 2012-07-02 : 08:43:05
|
| Hi,I am using SQL Developer tool for querying the data, and I am having 4 lakh records in a table, which I want to export to excel 2007 file.When I am exporting it my DataBase is getting hanged, even I tried to use rownum function but it work for only < (not >) and if I use <40K then how can I fetch next 3 Lack 60K records.Please help me to query so that I can export data from SQL Developer to Excel (I cant use SSIS for this as its selected data from SQL Developer)Thanks,AbhishekAbhishek |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-07-02 : 20:08:47
|
| what do you mean by sql developer tool? do you mean management studio?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2012-07-03 : 05:06:44
|
| Why dont you apply pagination?MadhivananFailing to plan is Planning to fail |
|
|
|
abhijaiswal.84
Starting Member
29 Posts |
Posted - 2012-07-05 : 01:03:12
|
| SQL Developer tool is used to write the Oracle syntax but it work with SQL Server, say u have a Oracle table but by using SQL Developer tool you can access that dataAbhishek |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-07-05 : 01:37:10
|
quote:
Originally posted by abhijaiswal.84
SQL Developer tool is used to write the Oracle syntax but it work with SQL Server, say u have a Oracle table but by using SQL Developer tool you can access that dataAbhishek
why not use sql server management studio and use linked server or openrowset methods?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
4 Lakh record from SQL Developer to Excel