1.1.1 Creating a Transact SQL Query
#1.1.1 Creating a Transact SQL Query
In Figure 4, after selecting the additional connection to which the query is added, click the New Query icon in the 2nd field. The query name is typed in field number 3. In field 4, the default Transact SQL Code is selected. After the SQL query is written in field number 5, the OK button is clicked.
In Figure 5, click the Save and Compile button in field 1 to save and run the query. If you do not want to write the query sentence manually, you can also have it created automatically with Query Builder. To open this tool, click the Query Builder button in area 1 in Figure 6.
Figure 7 lists the database tables in field 1. The table to write the query is selected and dragged to the middle section.
In Figure 8, the OK button is clicked after selecting the fields to be added to the query from the table column names in field 1. In Figure 9, click the Save and Compile button to save and run the query.