Active Query Builder - Visual query builder for .NET, ASP.NET, Delphi, Java and ActiveX
Active Query Builder
  • Home
  • Features
  • Downloads
  • Online Demo
  • Purchase
  • Documentation
  • Support
  • Customer's area
  1. Active Query Builder
  2. Common guide for all editions
  3. SQL Query modification

SQL Query modification

Follow New articles New articles and comments

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?
  • Programmer's Guides
  • Feedback Forum
  • Submit a request
  • My activities
scroll to top
© Copyright 2005-2018 ActiveDBSoft. All rights reserved.
Site Map Terms of Use Privacy Policy