Re: Cant create new query

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Also Itzik has a new book coming out next week, that might be a very good
choice for you:

http://www.sql.co.il/books/tsqlfund2008/




On 10/14/08 10:46 AM, in article
9B99655F-8017-4FD2-BCFA-DB8A31FE39A5@xxxxxxxxxxxxx, "Jim Jacoby"
<JimJacoby@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

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
    ... 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)
  • 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)
  • Re: Full Text Search Install Problem
    ... Then "Component Selection" window pops up, choose your SQL Server 2005 instance on the list and click Next button. ... In the Feature Maintenance window, choose Database Engine and click Next button again. ...
    (microsoft.public.sqlserver.setup)
  • Re: Anyone know how to get a directory listing...
    ... Microsoft's attach database dialog window only shows ... you the directory tree on the (remote) machine where SQL Server is running. ...
    (microsoft.public.dotnet.languages.csharp)