Embedded SQL for C and SQL Server
Embedded SQL Statements
For the Embedded SQL statements listed, an asterisk (*) identifies statements that have names identical to names of Transact-SQL statements. For statements with asterisks, the syntax included augments the standard Transact-SQL syntax.
BEGIN DECLARE SECTION | PREPARE |
CLOSE* | SELECT INTO* |
CONNECT TO | SET ANSI_DEFAULTS |
DECLARE CURSOR* | SET CONCURRENCY |
DELETE (POSITIONED)* | SET CONNECTION |
DELETE (SEARCHED)* | SET CURSOR_CLOSE_ON_COMMIT |
DESCRIBE | SET CURSORTYPE |
DISCONNECT | SET FETCHBUFFER |
END DECLARE SECTION | SET OPTION |
EXECUTE* | SET SCROLLOPTION |
EXECUTE IMMEDIATE | UPDATE (POSITIONED)* |
FETCH* | UPDATE (SEARCHED)* |
GET CONNECTION | WHENEVER |
OPEN* |