Re: Cant create new query

Books Online is a pretty good start; most of the books I have for T-SQL are
pretty advanced, maybe you could get Ken Henderson's Guru's Guide or Itzik's
Inside SQL Server book...




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: STORED PROCEDURE - passing table name as a parameter
    ... T-SQL, is that you get problems if the view definition does not fit into ... will need to query other system tables, for instance syscolumns. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • 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: Dinamyc Function
    ... This is T-SQL, this is not C#. ... virtue in T-SQL, it is not as big virtue as in an traditional programming ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Flattening Parent Child, an issue, please help
    ... AND t2.WBS_LEVEL = 2 LEFT OUTER JOIN ... I am using SQL Server 2000 with SP4. ... For information about dyamic SQL from T-SQL see ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)