View source for JDatabaseSQLSrv

=={{JVer|11.1}} JDatabaseSQLSrv==
===Description===


===Methods===
{| class="wikitable sortable"
|-
!Visibility
!Method name
!Description
|-
|public 
|[[API17:JDatabaseSQLSrv::__destruct|__destruct]]
|Destructor. 
|-
|public 
|[[API17:JDatabaseSQLSrv::connected|connected]]
|Determines if the connection to the server is active. 
|-
|public 
|[[API17:JDatabaseSQLSrv::dateToString|dateToString]]
|Method to get a  object represented as a datetime string in a format recognized by the database server. 
|-
|public 
|[[API17:JDatabaseSQLSrv::explain|explain]]
|Diagnostic method to return explain information for a query. 
|-
|public 
|[[API17:JDatabaseSQLSrv::getAffectedRows|getAffectedRows]]
|Get the number of affected rows for the previous executed SQL statement. 
|-
|public 
|[[API17:JDatabaseSQLSrv::getCollation|getCollation]]
|Method to get the database collation in use by sampling a text field of a table in the database. 
|-
|public 
|[[API17:JDatabaseSQLSrv::getEscaped|getEscaped]]
|Method to escape a string for usage in an SQL statement. 
|-
|public 
|[[API17:JDatabaseSQLSrv::getExporter|getExporter]]
|Gets an exporter class object. 
|-
|public 
|[[API17:JDatabaseSQLSrv::getImporter|getImporter]]
|Gets an importer class object. 
|-
|public 
|[[API17:JDatabaseSQLSrv::getNumRows|getNumRows]]
|Get the number of returned rows for the previous executed SQL statement. 
|-
|public 
|[[API17:JDatabaseSQLSrv::getQuery|getQuery]]
|Get the current or query, or new  object. 
|-
|public 
|[[API17:JDatabaseSQLSrv::getTableCreate|getTableCreate]]
|Shows the table CREATE statement that creates the given tables. 
|-
|public 
|[[API17:JDatabaseSQLSrv::getTableFields|getTableFields]]
|Retrieves field information about the given tables. 
|-
|public 
|[[API17:JDatabaseSQLSrv::getTableList|getTableList]]
|Method to get an array of all tables in the database. 
|-
|public 
|[[API17:JDatabaseSQLSrv::getVersion|getVersion]]
|Get the version of the database connector. 
|-
|public 
|[[API17:JDatabaseSQLSrv::hasUTF|hasUTF]]
|Determines if the database engine supports UTF-8 character encoding. 
|-
|public 
|[[API17:JDatabaseSQLSrv::insertid|insertid]]
|Method to get the auto-incremented value from the last INSERT statement. 
|-
|public 
|[[API17:JDatabaseSQLSrv::query|query]]
|Execute the SQL statement. 
|-
|public 
|[[API17:JDatabaseSQLSrv::queryBatch|queryBatch]]
|Execute a query batch. 
|-
|public 
|[[API17:JDatabaseSQLSrv::select|select]]
|Select a database for use. 
|-
|public 
|[[API17:JDatabaseSQLSrv::setUTF|setUTF]]
|Set the connection to use UTF-8 character encoding. 
|-
|public 
|[[API17:JDatabaseSQLSrv::transactionCommit|transactionCommit]]
|Method to commit a transaction. 
|-
|public 
|[[API17:JDatabaseSQLSrv::transactionRollback|transactionRollback]]
|Method to roll back a transaction. 
|-
|public 
|[[API17:JDatabaseSQLSrv::transactionStart|transactionStart]]
|Method to initialize a transaction. 
|-
|public static 
|[[API17:JDatabaseSQLSrv::test|test]]
|Test to see if the SQLSRV connector is available. 
|-
|protected 
|[[API17:JDatabaseSQLSrv::__construct|__construct]]
|Constructor. 
|-
|protected 
|[[API17:JDatabaseSQLSrv::fetchArray|fetchArray]]
|Method to fetch a row from the result set cursor as an array. 
|-
|protected 
|[[API17:JDatabaseSQLSrv::fetchAssoc|fetchAssoc]]
|Method to fetch a row from the result set cursor as an associative array. 
|-
|protected 
|[[API17:JDatabaseSQLSrv::fetchObject|fetchObject]]
|Method to fetch a row from the result set cursor as an object. 
|-
|protected 
|[[API17:JDatabaseSQLSrv::freeResult|freeResult]]
|Method to free up the memory used for the result set. 
|-
|}
* '''Defined in''' libraries/joomla/database/database/sqlsrv.php
* '''Extends''' [[API17:JDatabase|JDatabase]]
===Importing===
<source lang="php">jimport( 'joomla.database.database.sqlsrv' );</source>
===See also===
* {{JVer|11.1}} '''JDatabaseSQLSrv source code''' on [[jplatform:database/database/sqlsrv.php|BitBucket]]
* {{JVer|11.1}} Subpackage [[API17:Subpackage Database|Database]]
* [[API17:JDatabaseSQLSrv|Other versions of JDatabaseSQLSrv]]


===User contributed notes===
=== Code Examples ===
<dpl>
noresultsheader=\n
category=JDatabaseSQLSrv
namespace=CodeExample
category=ClassExample
include=*
namespace=CodeExample
format= ,,,
</dpl>
<noinclude>[[Category:Platform 11.1]][[Category:Archived pages API17]]</noinclude>