Re: Cant create new query

Tech-Archive recommends: Fix windows errors by optimizing your registry

Sounds good. I'll do that. Are there any books you recommend?

"Aaron Bertrand [SQL Server MVP]" wrote:

Don't do it. Just because it is easy doesn't make it "best"... Access (and
the visual designers) will teach you all kinds of bad habits. Learn
T-SQL... it will be worth it, I promise.


On 10/14/08 10:06 AM, in article
2048491E-6E03-40B8-B131-D2017BC9456F@xxxxxxxxxxxxx, "Jim Jacoby"
<JimJacoby@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Hi Aaron,
Thanks for taking the time to reply and for the insight. LOL. I agree. I
still find that the best way is to create the queries in Access using linked
tables and then copy-paste into SQL Server

"Aaron Bertrand [SQL Server MVP]" wrote:

From ssms 2005, when I select the New query all I get is a blank sql window.

That is by design, because SQL Server can't predict the query you want to
run, and expects you to type something. Did you try typing SELECT * FROM
some_table and hitting F5?

How do I open in the query grid window? ALso why is the query designer
window
always greyed out.

You may not think so at this moment, but this is probably a good thing. The
visual designers in SSMS are severely broken and aren't necessarily the best
way to accomplish anything in SQL Server.

I can't change the Query type.

What is a "Query type"? Do you mean SELECT vs. INSERT, or T-SQL vs. MDX, or
something else?




.

Relevant Pages

  • Re: Cant create new query
    ... the visual designers) will teach you all kinds of bad habits. ... window. ... because SQL Server can't predict the query you want to ... What is a "Query type"? ...
    (microsoft.public.sqlserver.tools)
  • Re: Cant create new query
    ... Books Online is a pretty good start; most of the books I have for T-SQL are ... the visual designers) will teach you all kinds of bad habits. ... tables and then copy-paste into SQL Server ...
    (microsoft.public.sqlserver.tools)
  • Re: Cant create new query
    ... still find that the best way is to create the queries in Access using linked ... because SQL Server can't predict the query you want to ... visual designers in SSMS are severely broken and aren't necessarily the best ... What is a "Query type"? ...
    (microsoft.public.sqlserver.tools)
  • Re: Cant create new query
    ... the visual designers) will teach you all kinds of bad habits. ... because SQL Server can't predict the query you want to ... What is a "Query type"? ... Do you mean SELECT vs. INSERT, or T-SQL vs. MDX, or ...
    (microsoft.public.sqlserver.tools)