📄 connection_setisolationlevel.html
字号:
<tr>
<td>
<p><STRONG><A
href="../ServerSpecific/Oracle.html" title="Oracle server specific information">Oracle</A></STRONG></p></td>
<td>
<P><STRONG>SA_ReadUncommitted</STRONG> = 'READ
COMMITTED'<BR><STRONG>SA_ReadCommitted</STRONG> = 'READ
COMMITTED'<BR><STRONG>SA_RepeatableRead</STRONG> =
'SERIALIZABLE'<BR><STRONG>SA_Serializable</STRONG> =
'SERIALIZABLE'</P></td></tr>
<tr>
<td>
<p><STRONG><A
href="../ServerSpecific/SQLServer_OleDb.html" title="SQL Server (OLE DB) specific information">SQL
Server (OLE DB)</A> </STRONG> </p></td>
<td>
<P><STRONG>SA_ReadUncommitted</STRONG> =
ISOLATIONLEVEL_READUNCOMMITTED ('Read
Uncommitted')<BR><STRONG>SA_ReadCommitted</STRONG> =
ISOLATIONLEVEL_READCOMMITTED
('Read Committed')<BR><STRONG>SA_RepeatableRead</STRONG> =
ISOLATIONLEVEL_REPEATABLEREAD
('Repeatable Read')<BR><STRONG>SA_Serializable</STRONG> =
ISOLATIONLEVEL_SERIALIZABLE
('Serializable')</P></td></tr>
<tr>
<td>
<p><STRONG><A
href="../ServerSpecific/SQLServer_DbLibrary.html" title="SQL Server (DB-Library) specific information">SQL
Server (DB-Library)</A> </STRONG> </p></td>
<td>
<P><STRONG>SA_ReadUncommitted</STRONG> = 'READ
UNCOMMITTED'<BR><STRONG>SA_ReadCommitted</STRONG> =
'READ COMMITTED'<BR><STRONG>SA_RepeatableRead</STRONG> =
'REPEATABLE READ'<BR><STRONG>SA_Serializable</STRONG> =
'SERIALIZABLE'</P></td></tr>
<TR>
<TD>
<p><STRONG><A
href="../ServerSpecific/Sybase.html" title="Sybase server specific information">Sybase</A> </STRONG>
</p>
<TD>
<P><STRONG>SA_ReadUncommitted</STRONG> = CS_OPT_LEVEL0 ('read
uncommitted')<BR><STRONG>SA_ReadCommitted</STRONG> =
CS_OPT_LEVEL1 ('read
committed')<BR><STRONG>SA_RepeatableRead</STRONG> = CS_OPT_LEVEL2
('repeatable
read')<BR><STRONG>SA_Serializable</STRONG> =
CS_OPT_LEVEL3
('serializable')</P>
<tr>
<td>
<p><STRONG><A
href="../ServerSpecific/DB2.html" title="DB2 server specific information">DB2</A></STRONG> </p></td>
<td>
<P><STRONG>SA_ReadUncommitted</STRONG> =
SQL_TXN_READ_UNCOMMITTED ('Uncommited
Read')<BR><STRONG>SA_ReadCommitted</STRONG> = SQL_TXN_READ_COMMITTED
('Cursor Stability')<BR><STRONG>SA_RepeatableRead</STRONG> =
SQL_TXN_REPEATABLE_READ
('Repeatable Read')<BR><STRONG>SA_Serializable</STRONG> = SQL_TXN_SERIALIZABLE
('Read
Stability')</P></td></tr>
<tr>
<td>
<p><STRONG><A
href="../ServerSpecific/Informix.html" title="Informix server specific information">Informix</A></STRONG>
</p></td>
<td>
<P><STRONG>SA_ReadUncommitted</STRONG> =
SQL_TXN_READ_UNCOMMITTED<BR><STRONG>SA_ReadCommitted</STRONG> =
SQL_TXN_READ_COMMITTED<BR >
<STRONG>SA_RepeatableRead</STRONG> =
SQL_TXN_REPEATABLE_READ<BR><STRONG>SA_Serializable</STRONG> =
SQL_TXN_SERIALIZABLE</P></td></tr>
<tr>
<td>
<p><STRONG><A
href="../ServerSpecific/InterBase.html" title="InterBase server specific information">InterBase</A></STRONG></p></td>
<td>
<P><STRONG>SA_ReadUncommitted</STRONG> =
isc_tpb_read_committed,
isc_tpb_rec_version<BR><STRONG>SA_ReadCommitted</STRONG> =
isc_tpb_read_committed,
isc_tpb_no_rec_version<BR><STRONG>SA_RepeatableRead</STRONG>
=
isc_tpb_consistency<BR><STRONG>SA_Serializable</STRONG>
=
isc_tpb_concurrency</P></td></tr>
<tr>
<td>
<p><STRONG><A
href="../ServerSpecific/SQLBase.html" title="SQLBase server specific information">SQLBase</A></STRONG></p></td>
<td>
<P><STRONG>SA_ReadUncommitted</STRONG> = SQLILRL
('RL')<BR><STRONG>SA_ReadCommitted</STRONG> = SQLILCS
('CS')<BR><STRONG>SA_RepeatableRead</STRONG> = SQLILRR
('RR')<BR><STRONG>SA_Serializable</STRONG> =
SQLILRO ('RO')</P></td></tr>
<tr>
<td>
<p><STRONG><A
href="../ServerSpecific/MySQL.html" title="MySQL server specific information">MySQL</A></STRONG></p></td>
<td>
<P><STRONG>SA_ReadUncommitted</STRONG> = 'READ
UNCOMMITTED'<BR><STRONG>SA_ReadCommitted</STRONG> =
'READ COMMITTED'<BR><STRONG>SA_RepeatableRead</STRONG> =
'REPEATABLE READ'<BR><STRONG>SA_Serializable</STRONG> =
'SERIALIZABLE'</P></td></tr>
<tr>
<td>
<p><STRONG><A
href="../ServerSpecific/PostgreSQL.html" title="PostgreSQL server specific information">PostgreSQL</A></STRONG></p></td>
<td>
<P><STRONG>SA_ReadUncommitted</STRONG> = 'READ
COMMITTED'<BR><STRONG>SA_ReadCommitted</STRONG> =
'READ COMMITTED'<BR><STRONG>SA_RepeatableRead</STRONG> =
'READ COMMITTED'<BR><STRONG>SA_Serializable</STRONG> =
'SERIALIZABLE'</P></td></tr>
<tr>
<td>
<p><STRONG><A
href="../ServerSpecific/ODBC.html" title="ODBC server specific information">ODBC</A></STRONG></p></td>
<td>
<P><STRONG>SA_ReadUncommitted</STRONG> =
SQL_TXN_READ_UNCOMMITTED<BR><STRONG>SA_ReadCommitted</STRONG>
=
SQL_TXN_READ_COMMITTED<BR><STRONG>SA_RepeatableRead</STRONG>
=
SQL_TXN_REPEATABLE_READ<BR><STRONG>SA_Serializable</STRONG>
=
SQL_TXN_SERIALIZABLE</P></td></tr>
</table> </p>
<h3>See also</h3>
<p>
<A href="Connection_IsolationLevel.html" target="" >IsolationLevel</A>
</p>
<p><A href="../HowTo/errors.html" target="" >Error handling</A> </p>
<h3>Problems and Questions</h3>
<p> If
you haven't found the answer to your questions or
have some problems on using the Library, please, send e-mail to <A href="mailto:howto@sqlapi.com">howto@sqlapi.com</A>.
</p>
</td>
<tr></tr>
</table>
</body></html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -