Re: Query Designer

Tech-Archive recommends: Fix windows errors by optimizing your registry



Also see the thread I started 'Change Type in Management Studio" in this
same group. 9/17/2006

You can add comment to the active item;

FeedbackID=124911
http://connect.microsoft.com/site/sitehome.aspx?SiteID=68

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"Andy in S. Jersey" wrote:
| Keith,
|
| I think I understand the response, but not all of it.
|
| Right now I can create a new query and then right click within the query
| window and select Design Query in Editor. From there I can indeed design
a
| query. I can not Execute SQL from Query Designer, but I can click OK and
get
| the SQL I have created back in the New Query window. From there I can
| Execute.
|
| You will be working on being able to Execute SQL in Query Designer in some
| later release?
|
| Is this a correct interpretation?
|
| Thanks,
|
| Andy
|
| "Keith.Wilson@xxxxxxxxxxxxxxxxxxxx" wrote:
|
| > Andy,
| >
| > Thank you for providing the feedback in this space. The design decison
for
| > Yukon was to have existing behaviour. We considered the approach
proposed,
| > unfortunatly the scope of changes required in order for a different
approach
| > to work correctly is beoynd a service pack fix. We are tracking the
request
| > in our database for considaration in future releases.
| >
| > Regards,
| >
| > Keith Wilson
| > Microsoft SQL Server
| >
| > ==================================================
| >
| > When responding to posts, please "Reply to Group" via your newsreader so
| > that others may learn and benefit from your issue.
| >
| > ==================================================
| > This posting is provided "AS IS" with no warranties, and confers no
rights.
| >
| >
| > "Andy in S. Jersey" wrote:
| >
| > > While in SQL Server Management Studio I right clicked and selected
| > >
| > > Design Query in Editor ...
| > >
| > > I am able to design a query in Query Designer, but I cannot Execute
SQL, it
| > > is ghosted out and I can't select it.
| > >
| > >
| > > Using Microsoft SQL Server Management Studio 9.00.2047.00
| > >
| > > Installed a service pack last week.
| > >
| > >
| > >


.



Relevant Pages

  • Re: bypassing some of the parameters in a parameter query
    ... >> Well, WHERE does work in design view, but having a lot of ANDs and ORs ... what is simple and direct logic in SQL View ... >> query to design view and see if it makes sense to you. ... >> Tom Ellison ...
    (microsoft.public.access.queries)
  • Re: Future of ADPs
    ... To get there from the main window of SQL EM, click on Tools, then SQL Query ... Regardless of how I feel about it as a design tool, ...
    (microsoft.public.access.adp.sqlserver)
  • RE: Designing Query - Help Please ASAP
    ... The changes made to the SQL of the query result from switching into design ... SELECT [tblProject Staffing Resources].ProjectID, [tblProject Staffing ...
    (microsoft.public.access.queries)
  • Re: Expression Left in query giving syntax error
    ... trying to change focus from the field of the design grid. ... Next I tried coding the whole SQL expression including the Left function ... directly in the SQL window. ... The query is made of only one single table - so no ambiguities possible. ...
    (comp.databases.ms-access)
  • Re: Is this join valid?
    ... > complex set of tables and queries, but I've boiled down the behavior ... you describe a problem with the Design View that really should not ... affect what happens when running a query from ASP. ... > the SQL view after creating the query in Design View. ...
    (microsoft.public.inetserver.asp.db)