Friday, March 02, 2012 12:26 PM
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?
Friday, March 02, 2012 1:56 PMhere are steps http://hodentekhelp.blogspot.com/2008/10/how-do-you-use-query-designer-in-sql.html
Friday, March 02, 2012 1:57 PM
HOW it is "greyed out"?
And link is broken.
www.sqlCMD.ru - all around MS SQL Server
Friday, March 02, 2012 2:02 PMI 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.
- Edited by poppy1 Friday, March 02, 2012 2:03 PM
Friday, March 02, 2012 2:03 PMIf you follow the link in my original question it covers it.
Friday, March 02, 2012 2:18 PM
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)
- Edited by RamJaddu Friday, March 02, 2012 2:20 PM
Friday, March 02, 2012 2:26 PM
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.
Friday, March 02, 2012 7:53 PMModerator
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.