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 |
|
suketu9
Starting Member
13 Posts |
 Posted - 2006-10-02 : 17:51:40
|
| I am new to SQL. I have this query which I can only run from command prompt since I dont have access to the server and I have to remote into this server and run the query from command prompt, since we dont have enterprise manager installed on it. I use osql command to output the query result to a txt file. But the formatting is not good. what do i need to put in the query so i can see the the table format in the output.following is the query.select * from icBoaSwitchLastTransferF000 where bbr_value_date >= 'Sep 01 2006 00:00:00' and bbr_value_date <= 'Sep 15 2006 23:59:59'; Thanks |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2006-10-02 : 17:55:11
|
| If you have BCP available, this will give you a formatted output if you set the right parameters. Have a look in Books Online for more info. |
 |
|
|
|
|
|
Formattin SQL Output