SQL Query modification
Learn how to create SQL queries from scratch or to edit existing SQL queries with Active Query Builder
- How to create a simple query programmatically?
- How to change sorting, add filters, limits and aggregations to the query?
- How to add the "with (nolock)" hint to all datasources in the query?
- How to specify the stored procedure parameters programmatically?
- Generation of INSERT, UPDATE, DELETE statements for a given SELECT statement
- How to check if a query contains specific tables and they are joined correctly?
- How to add or modify TOP, LIMIT, FETCH FIRST clauses or ROWNUM condition programmatically?
- How to join an object that has just been added by the user with existing objects in the query?
- How to take additional actions when the user adds an object to the Design Pane?
- How to add objects and joins to the query programmatically?
- How to add the DISTINCT keyword to the query programmatically?
- How to rename a table in the query (replace all occurrences) programmatically?
- How to change aliases for query output columns programmatically?