Data using Manual query
Goal: Setup a workbook formula that pulls the data from the database (use the given connection string), extract all the data using manual query from the given table, the data should have "PIN" greater than 11 and sorted according to the "Name".
Connection String: Data Source=(local)\SQLEXPRESS;Integrated Security=True;User ID=SheetKraft;Initial Catalog=testdb1
Table Name: "dbo"."dummy"
- Use the UI DataFromDatabase.SK, connect to the relevant datasource using above given connection string.
- Select the Manual query radio button and write manual query to extract the relevant data.
- Pre-requisites for writing a query.