vcg07.htm

Visual C++与数据库的连接经典实例

ROLLBACK

</FONT>

<TD><FONT COLOR=#000080><BR></FONT>



<TD><FONT COLOR=#000080><BR></FONT>



<TD><FONT COLOR=#000080><BR></FONT>



<TR>

<TD><FONT COLOR=#000080><BR></FONT>



<TD><FONT COLOR=#000080>

TRANSACTION

</FONT>

<TD><FONT COLOR=#000080><BR></FONT>



<TD><FONT COLOR=#000080><BR></FONT>



<TD><FONT COLOR=#000080><BR></FONT>



<TR>

<TD><FONT COLOR=#000080>

Core

</FONT>

<TD><FONT COLOR=#000080>

Full SELECT,

</FONT>

<TD><FONT COLOR=#000080>

ALTER

</FONT>

<TD><FONT COLOR=#000080>

SQL_VARCHAR,

</FONT>

<TD><FONT COLOR=#000080>

Subqueries

</FONT>

<TR>

<TD><FONT COLOR=#000080><BR></FONT>



<TD><FONT COLOR=#000080>

positioned

</FONT>

<TD><FONT COLOR=#000080>

TABLE,

</FONT>

<TD><FONT COLOR=#000080>

SQL_DECIMAL,

</FONT>

<TD><FONT COLOR=#000080>

and aggregate

</FONT>

<TR>

<TD><FONT COLOR=#000080><BR></FONT>



<TD><FONT COLOR=#000080>

UPDATE, and

</FONT>

<TD><FONT COLOR=#000080>

CREATE

</FONT>

<TD><FONT COLOR=#000080>

SQL_NUMERIC,

</FONT>

<TD><FONT COLOR=#000080>

functions

</FONT>

<TR>

<TD><FONT COLOR=#000080><BR></FONT>



<TD><FONT COLOR=#000080>

positioned

</FONT>

<TD><FONT COLOR=#000080>

INDEX,

</FONT>

<TD><FONT COLOR=#000080>

SQL_SMALLINT,

</FONT>

<TD><FONT COLOR=#000080><BR></FONT>



<TR>

<TD><FONT COLOR=#000080><BR></FONT>



<TD><FONT COLOR=#000080>

DELETE

</FONT>

<TD><FONT COLOR=#000080>

DROP

</FONT>

<TD><FONT COLOR=#000080>

SQL_INTEGER,

</FONT>

<TD><FONT COLOR=#000080><BR></FONT>



<TR>

<TD><FONT COLOR=#000080><BR></FONT>



<TD><FONT COLOR=#000080><BR></FONT>



<TD><FONT COLOR=#000080>

INDEX,

</FONT>

<TD><FONT COLOR=#000080>

SQL_REAL,

</FONT>

<TD><FONT COLOR=#000080><BR></FONT>



<TR>

<TD><FONT COLOR=#000080><BR></FONT>



<TD><FONT COLOR=#000080><BR></FONT>



<TD><FONT COLOR=#000080>

CREATE

</FONT>

<TD><FONT COLOR=#000080>

SQL_FLOAT,

</FONT>

<TD><FONT COLOR=#000080><BR></FONT>



<TR>

<TD><FONT COLOR=#000080><BR></FONT>



<TD><FONT COLOR=#000080><BR></FONT>



<TD><FONT COLOR=#000080>

VIEW,

</FONT>

<TD><FONT COLOR=#000080>

SQL

</FONT>

<TD><FONT COLOR=#000080><BR></FONT>



<TR>

<TD><FONT COLOR=#000080><BR></FONT>



<TD><FONT COLOR=#000080><BR></FONT>



<TD><FONT COLOR=#000080>

DROP

</FONT>

<TD><FONT COLOR=#000080>

DOUBLEPRECISION

</FONT>

<TD><FONT COLOR=#000080><BR></FONT>



<TR>

<TD><FONT COLOR=#000080><BR></FONT>



<TD><FONT COLOR=#000080><BR></FONT>



<TD><FONT COLOR=#000080>

VIEW,

</FONT>

<TD><FONT COLOR=#000080><BR></FONT>



<TD><FONT COLOR=#000080><BR></FONT>



<TR>

<TD><FONT COLOR=#000080>

GRANT,

</FONT>

<TD><FONT COLOR=#000080><BR></FONT>



<TD><FONT COLOR=#000080><BR></FONT>



<TD><FONT COLOR=#000080><BR></FONT>



<TD><FONT COLOR=#000080><BR></FONT>



<TR>

<TD><FONT COLOR=#000080><BR></FONT>



<TD><FONT COLOR=#000080><BR></FONT>



<TD><FONT COLOR=#000080>

REVOKE

</FONT>

<TD><FONT COLOR=#000080><BR></FONT>



<TD><FONT COLOR=#000080><BR></FONT>



<TR>

<TD><FONT COLOR=#000080>

Extended

</FONT>

<TD><FONT COLOR=#000080>

LEFT OUTER

</FONT>

<TD><FONT COLOR=#000080>

Batch SQL

</FONT>

<TD><FONT COLOR=#000080>

SQL_LONGVARCHAR,

</FONT>

<TD><FONT COLOR=#000080>

SUBSTRING, ABS

</FONT>

<TR>

<TD><FONT COLOR=#000080><BR></FONT>



<TD><FONT COLOR=#000080>

JOIN, RIGHT

</FONT>

<TD><FONT COLOR=#000080>

statements,

</FONT>

<TD><FONT COLOR=#000080>

SQL_BIT,

</FONT>

<TD><FONT COLOR=#000080><BR></FONT>



<TR>

<TD><FONT COLOR=#000080><BR></FONT>



<TD><FONT COLOR=#000080>

OUTER JOIN

</FONT>

<TD><FONT COLOR=#000080>

stored

</FONT>

<TD><FONT COLOR=#000080>

SQL_TINYINT,

</FONT>

<TD><FONT COLOR=#000080><BR></FONT>



<TR>

<TD><FONT COLOR=#000080><BR></FONT>



<TD><FONT COLOR=#000080><BR></FONT>



<TD><FONT COLOR=#000080>

procedures

</FONT>

<TD><FONT COLOR=#000080>

SQL_BIGINT,

</FONT>

<TD><FONT COLOR=#000080><BR></FONT>



<TR>

<TD><FONT COLOR=#000080><BR></FONT>



<TD><FONT COLOR=#000080><BR></FONT>



<TD><FONT COLOR=#000080><BR></FONT>



<TD><FONT COLOR=#000080>

SQL_BINARY,

</FONT>

<TD BGCOLOR=#80FFFF ><FONT COLOR=#000080><BR></FONT>



<TR>

<TD BGCOLOR=#80FFFF ><FONT COLOR=#000080><BR></FONT>



<TD BGCOLOR=#80FFFF ><FONT COLOR=#000080><BR></FONT>



<TD BGCOLOR=#80FFFF ><FONT COLOR=#000080><BR></FONT>



<TD BGCOLOR=#80FFFF ><FONT COLOR=#000080>

SQL_VARBINARY,

</FONT>

<TD BGCOLOR=#80FFFF ><FONT COLOR=#000080><BR></FONT>



<TR>

<TD BGCOLOR=#80FFFF ><FONT COLOR=#000080><BR></FONT>



<TD BGCOLOR=#80FFFF ><FONT COLOR=#000080><BR></FONT>



<TD BGCOLOR=#80FFFF ><FONT COLOR=#000080><BR></FONT>



<TD BGCOLOR=#80FFFF ><FONT COLOR=#000080>

SQL_LONGVARBINARY,

</FONT>

<TD BGCOLOR=#80FFFF ><FONT COLOR=#000080><BR></FONT>



<TR>

<TD BGCOLOR=#80FFFF ><FONT COLOR=#000080><BR></FONT>



<TD  BGCOLOR=#80FFFF ><FONT COLOR=#000080><BR></FONT>



<TD BGCOLOR=#80FFFF ><FONT COLOR=#000080><BR></FONT>



<TD BGCOLOR=#80FFFF ><FONT COLOR=#000080>

SQL_DATE,

</FONT>

<TD BGCOLOR=#80FFFF ><FONT COLOR=#000080><BR></FONT>



<TR>

<TD BGCOLOR=#80FFFF ><FONT COLOR=#000080><BR></FONT>



<TD BGCOLOR=#80FFFF ><FONT COLOR=#000080><BR></FONT>



<TD BGCOLOR=#80FFFF ><FONT COLOR=#000080><BR></FONT>



<TD BGCOLOR=#80FFFF ><FONT COLOR=#000080>

SQL_TIME,

</FONT>

<TD BGCOLOR=#80FFFF ><FONT COLOR=#000080><BR></FONT>