Statements

This chapter describes the Embedded SQL statements that are listed below. An asterisk (*) identifies statements that have names that are identical to names of Transact-SQL statements. For statements with asterisks, the syntax that is included in this chapter 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*


For more information about standard Transact-SQL statements and syntax, see the Microsoft SQL Server Transact-SQL Reference and the Microsoft SQL Server Database Developer's Companion.