TurboSQL Guide

TurboSQL is a subset of SQL 92 that contains all of minimal SQL as described by the MS ODBC specification and is very similar to Local SQL used with Embarcadero Database Engine.

Conventions

•	Table Names

•	Column Names

•	String Literals

•	Date Formats

•	Time Formats

•	DateTime Formats

•	Boolean Literals

•	Table Correlation Names

•	Column Correlation Names

•	Command Parameters

•	Embedded Comments

Data Manipulation Language

•

Overview

•	DELETE Statement

•	FROM Clause

•	GROUP BY Clause

•	INSERT Statement

•	ORDER BY Clause

•	SELECT Statement

•	UPDATE Statement

•	WHERE Clause

Data Definition Language

•

Overview

•	CREATE TABLE Command

•	ALTER TABLE Command

•	CREATE INDEX Command

•	DROP Command

•	Column Data Types

Programming Language

•

Overview

•	CALL Statement

•	CREATE FUNCTION Statement

•	CREATE PROCEDURE Statement

•	CREATE AGGREGATE Statement

•	DROP FUNCTION/PROCEDURE/AGGREGATE Statement

•	DECLARE Statement

•	IF Statement

•	SET Statement

•	WHILE Statement

•	Exchanging Parameters with .NET Assemblies