call me stupid or whatever, i don't care.
i have found the new query editor in 2008 have the most restrictive and pain in the a$$ feature i have ever seen.
every query now requires brackets, fully qualified dabase name + table + column for reference.
WHY am i required to type the name of the database i'm querying in a stored procedure? COMPLETELY POINTLESS!
PLUS on top of all of that, the junk is CASE SENSITIVE. if i wanted to waste time worrying about caps, braces and meaningless syntactical characters, i would write code in C#.
the reason why this is SUCH AN INCONVENIENCE is that the database i am writing against has HUNDREDS of tables.
additionally, i've used 2005 for years and i really find it highly inconvenient to use the same tool as before but now i need to write queries in proper english and case.
here's a quick example:
previously i could type 'select top 5 zipcode from shipment
NOW with the new and improved pain in the a$$ feature i have to type:
'select top 5 '[databasename].[dbo].[shipment].[zipcode] from [databasename].[dbo].[shipment]'
that might not be an exact example but you get the idea.
maybe i just don't know what the new intellisense feature is that controls this?
somebody please help me figure out how to turn off this restriction, it is
View Complete Post