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 |
MattC
Starting Member
9 Posts |
Posted - 2012-12-20 : 10:11:21
|
I have a simple query: SELECT timezone_id,city_id,state_idFROM cityWHERE (city_id = 'ANCHORAGE' AND state_id = 'AK')in MS SQL Server Management Studio it returns: timezone_id city_id state_idUS/Alaska, ANCHORAGE, AK But in Toad it returns: timezone_id city_id state_id{null}, ANCHORAGE, AKNotice that Toad returns a timezone value of "{null}" but Mgnt Studio return the correct value "US/Alaska"Any ideas or suggestions?Thanks in advance,Matt |
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-12-20 : 10:31:07
|
Are you sure they're both connected to the same database on the same server with the same login credentials? If so then you'd have to contact Quest and file a bug report. |
|
|
|
|
|