Freitag, 2. März 2012 12:26
I want to be able to execute a query in the query designer window but it is greyed out.
I found this answer on these forums but do not understand the instructions:
It mentions an OPEN TABLE feature which I cant see any where.
I just dont get it.
Can someone explain this to me please?
Freitag, 2. März 2012 13:56here are steps http://hodentekhelp.blogspot.com/2008/10/how-do-you-use-query-designer-in-sql.html
Freitag, 2. März 2012 13:57
HOW it is "greyed out"?
And link is broken.
www.sqlCMD.ru - all around MS SQL Server
Freitag, 2. März 2012 14:02I have already looked at that but it doesn't actually tell me how to execute the query. When you right click on the query the context menu shows Execute as disabled.
- Bearbeitet poppy1 Freitag, 2. März 2012 14:03
Freitag, 2. März 2012 14:03If you follow the link in my original question it covers it.
Freitag, 2. März 2012 14:18
Query desinger is only to generate query - also you must select correct database before start desinger
To execute you have to Press F5 once query genetion completed by desinger. Its does not run on its own (Or on query window press execute button)
- Bearbeitet RamJaddu Freitag, 2. März 2012 14:20
Freitag, 2. März 2012 14:26
F5 does not execute a query in the query designer.
You need to leave query designer first. I want to execute within the query designer so that I can use the visual tools to add/remove tables and alter my query. If you follow my first link they explain how to do it but I cant get my head around it.
- Bearbeitet poppy1 Freitag, 2. März 2012 14:28
Freitag, 2. März 2012 19:53Moderator
poppy1, the link you supplied in your original post is broken. I'm guessing the link you were referring to was a post by Steve Twitchell (here). His suggestion of using "Open Table" refers to the terminology used by SQL Server 2005 SSMS. Using the latest tools, it is the same idea, just different wording. Try this out to see if it makes sense.
1. In SSMS, right-click on one of the tables you want to use in your query and click "Edit Top 200 Rows"
2. In the results pane, right click and add Pane -> Diagram (and also Pane -> SQL)
3. This will give you essentially the Query Designer functionality with the additional benefit of running your queries as you tinker with the designer
Sam Lester (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you. This can be beneficial to other community members reading the thread.