Works in Management Studio but not Toad

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

Works in Management Studio but not Toad

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_id
FROM city
WHERE (city_id = 'ANCHORAGE' AND state_id = 'AK')

in MS SQL Server Management Studio it returns:

timezone_id city_id state_id
US/Alaska, ANCHORAGE, AK

But in Toad it returns:

timezone_id city_id state_id
{null}, ANCHORAGE, AK

Notice 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.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources