Naming Conventions

Embedded SQL keywords and statements in your programs are not case-sensitive. For example, the following Embedded SQL statement fragments are equivalent:

EXEC SQL CONNECT TO
exec sql connect to
Exec Sql Connect To

However, embedded SQL cursor, prepared statement, and connection names are case-sensitive. The same case must be used to declare and use these names. For example, the following fragments declare two different cursors:

DECLARE CUR_NAME CURSOR
DECLARE cur_name CURSOR

The sort order of the SQL Server you are connecting to determines whether other words are case-sensitive.

Note that hyphens (-) are not permitted in Transact-SQL identifiers such as table and column names.