 | |
Cant create new query
microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools
 |
| | Thread Tools | Display Modes |
#51
 
| |||
| |||
|
Re: Cant create new query -
10-14-2008
, 12:12 PM
|
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...soft (DOT) com, "Jim Jacoby" JimJacoby (AT) discussions (DOT) microsoft.com> 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? |
#52
| |||
| |||
|
|
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...soft (DOT) com, "Jim Jacoby" JimJacoby (AT) discussions (DOT) microsoft.com> 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? |
#53
| |||
| |||
|
|
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...soft (DOT) com, "Jim Jacoby" JimJacoby (AT) discussions (DOT) microsoft.com> 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? |
#54
| |||
| |||
|
|
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...soft (DOT) com, "Jim Jacoby" JimJacoby (AT) discussions (DOT) microsoft.com> 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? |
#55
| |||
| |||
|
|
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...soft (DOT) com, "Jim Jacoby" JimJacoby (AT) discussions (DOT) microsoft.com> 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? |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.