Monday, March 26, 2012

How to Change Query Type ?(Mangagement Studio)

Why the "Change Type" Button of the "Query Designer Toolbar " is alwayse Disable(gray color) ,then how can i switch the query between "selelct","update","Insert" and "Delete"? I am using Nov 7 released 180 Days Trial Version.(Sql Server Management Studio)

Thannks!

The Query toolbar is associated with Query Designer documents. The only way to display such a document in Management Studio is using the Open Table/Open View functionality for tables or views. The change type drop down is disabled in Open Table because we don't allow the Visual Studio Query Designer (which is displaying the query) to change the query type for Open Table. In Visual Studio, this restriction is lifted for Query Designer documents.

You can do what you want to do by creating a new query (click the New Query button), typing some text (say, "select"), highlighting the text you typed, right-clicking to bring up a context menu, and selecting "Design Query in Editor." In the Query Designer dialog that appears, you can right click in the upper pane and add tables. You can also right click and change the query type from the context menu.|||I see,Thank you for your Reply

No comments:

Post a Comment