Switch to: V9V8V7V6V5

Valentina SQL TIPs

Conventions

TIP: Write SQL keywords in UPPER CASE

TIP: Define names for Tables, Fields, ... with corresponded prefix

TIP: Define names for ObjectPtr and FK fields with suffix "Ptr"

SQL Query Formatting

Formatting FROM Clause

TIP: We suggest the following format for most queries that build JOINS:

Formatting WHERE Clause

TIP: Put each condition on a separate line.

TIP: Group the search conditions for the same table together.

TIP: Make it easy to comment out each condition.

SELECT Conditions

TIP: Differ Link And Search Conditions

TIP: Always prefer to specify a link condition in the FROM clause instead of WHERE clause

TIP: Write join paths using natural way

TIP: Custom Error Code for Stored Procedure

TIP: Hierarchical query and object-pointer operator.