how to change query in materialized view?
537697
['To change its storage characteristics.', 'To change its refresh method, mode, or time.', 'To alter its structure so that it is a different type of materialized view.', 'To enable or disable query rewrite.']
1226041
You can change which is the lookup/1-side table and which is the many-side, either by clicking and dragging from the many to the one, or by switching the tables in the edit relationship dialog.
1204472
['Go to the tab Home -> select Merge Queries.', 'Merge the query CountriesCurrencies with BusinessUnits.', 'Select the column Join as merge column for both queries.', 'For the merge use join kind Full Outer (all rows from both) -> press OK.']
1435644
['Create a standard Select query. ... ', 'Select Query → Update to change the type of query to an update action query.', 'Drag the field to be updated in the target table to the query grid. ... ', 'Optionally specify criteria to limit the rows to be updated.']
105200
['leave Search term blank.', 'select Occurs anywhere.', 'in Schemas to search select from which schemas you want list of tables.', 'check Search object names and in this section check Tables.', 'uncheck Search column names and Search source.']
40021
If the view contains joins between multiple tables, you can only insert and update one table in the view, and you can't delete rows. You can't directly modify data in views based on union queries. You can't modify data in views that use GROUP BY or DISTINCT statements.
986309
['In Object Explorer, connect to an instance of Database Engine.', 'In Object Explorer, right-click the table in which you want to rename columns and choose Rename.', 'Type a new column name.']
1395308
['Click the Open Object Query Language Studio to execute statements button ( ) in the toolbar.', 'Type your query in the OQL editor pane. ... ', 'Press F5 or Ctrl+Enter to run the query, or select the Execute Query button ( ) from the toolbar.']
466718
['INSERT – adding new rows to a table. Basic Syntax. Using a Column List. INSERT INTO SELECT.', 'UPDATE – updating values of fields.', 'DELETE – deleting rows from a table.', 'MERGE – merging tables.', 'TRANSACTIONS – learn what transactions are and how they can be managed.']
83122
['Launch SQL Server Management Studio, and connect to the SQL Server 2012 Database Engine where you want to configure MDW.', 'Expand the Management section, and right-click Data Collection.', 'From the context menu, select Configure Management Data Warehouse, as shown in Figure 43.1. ... ', 'Click the Next button.']
968377
Click on Settings-->Settings in the menu bar as below and uncheck the Graphical Query Painter checkbox. Now you can see the List Layout in the below format and you can change the order of the fields that appear in the output by changing the Sequence numbers accordingly.
1180297
To define a query parameter in MDX in Query mode ). The Query Parameters dialog box opens. In the Parameter column, click <Enter Parameter>, and then type the name of a parameter. In the Dimension column, choose a value from the drop-down list.
849368
You can change the collation of any new objects that are created in a user database by using the COLLATE clause of the ALTER DATABASE statement. This statement does not change the collation of the columns in any existing user-defined tables. These can be changed by using the COLLATE clause of ALTER TABLE.
308131
['Go to the Data tab.', 'In the Get & Transform group, click on the New Query drop down.', "Hover your cursor on 'From File' and click on 'From Folder'."]
630926
['Choose Open ® Queries in the BEx toolbar. The BEx Open Dialog appears.', 'From here, choose a query from the queries in your history, favorites or roles, or from queries assigned to the InfoAreas. Then select it.', 'Choose Change.']
87121
['Open the SAP Query main screen via transaction SQ01.', 'Follow the menu path Queries > Convert QuickViews, which will launch a dialog box.', 'Select your QuickView from the dropdown box and click on the enter button.']
1457519
['Choose View Settings in the View tab.', 'Make modifications to presented options in the Advanced View settings window.', 'Click OK.', 'Click Change View in the View tab.', 'Select Manage Views.', 'Choose Current view settings under Views for folder.', 'Select Copy.', 'Enter a name.']