Server Explorer questions

[Andrzejek]

Server Explorer in VS 2010 (looks pretty much like Data Environment in VB 6 which I like and use a lot).

I can connect to my ORACLE database no problem. Displayes all tables, views, etc.
I can right-click on my connection and choose 'New Query', select table(s) for my query and I can run my Select statement and the data is displayed on the buttom. Fine.

1. How can I save that query I just created so I don't have to re-created it every time I open VS? I can create several new queries, but I see no way to save any of them :-( (VB 6 Data Env I can save as many as I want, and return to them any time, they are saved.)

2. If I have Date field(s), Server Explorer displays just the date part, and no time part:

[pre]
SomeDateField OtherDateField
5/5/2012 6/6/2012
12/10/2012 12/12/2012
[/pre]

If I use other tools (TOAD, VB 6) I get the true value of that fields:

[pre]
SomeDateField OtherDateField
10/16/2012 4:44:57 PM 10/16/2012 4:45:36 PM
10/17/2012 7:39:21 AM 10/17/2012 7:39:35 AM
[/pre]

I know I can force the display:[tt]
Select TO_CHAR(MyDateField, 'MM/DD/YYYY HH:MM:SS') AS Something[/tt]
but that's not the way to go.

It there a setting in Server Explorer I've missed?

Have fun.

---- Andy