Home Dashboard Directory Help

Execute query in designer by moondaddy



Sign in
to vote
Type: Suggestion
ID: 807773
Opened: 11/5/2013 6:24:18 AM
Access Restriction: Public


In VS 2008 and earlier we could design sql in the designer and then execute it in the designer for a quick test. Now we're forced to use SSMS to access the query designer but in most cases the Execute Query button is disabled. The only time we can execute the query is when we right click on a table in the Object Explorer and right click Edit Top 200 Rows. From there we can click on buttons to show the various designer panes (http://www.functionx.com/sqlserver/Lesson16.htm).

I NEVER design queries from here and am always working on complex SQL in stored procedures. We need to be able to simply select some text in the stored procedure window and then do a right click and select Design SQL for a query window that lets us execute the query (as we could in VS 2008).
Sign in to post a comment.
Posted by Microsoft on 11/11/2013 at 2:47 PM
Thanks for the feedback. We'll keep this item active so that other members of the community get a chance to see it and provide their own input. We'll keep an eye on it as we plan the next big things for SQL.
Sign in to post a workaround.
File Name Submitted By Submitted On File Size  
2008 query designer.png 11/5/2013 17 KB