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.