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* |