Class QSqlServer2005Database

Database Adapter for Microsoft SQL Server 2005/2008

LimitInfo and Query utilizes an interal SQL tag QCUBED_OFFSET<#>, where # represents the number of rows to offset for "Limit"-based queries. The QCUBED_OFFSET is added internally by SqlLimitVariablePrefix(), and it is handled (and removed from the query) by Query(). In error messages and DB profiling, the QCUBED_OFFSET<#> tag WILL appear (if applicable). The framework will handle this gracefully, but obviously, if you try and cut and paste SQL code that contains QCUBED_OFFSET<#> into QueryAnalyzer, the query will fail, so just be aware of that. If you want to do something like test queries with QueryAnalyzer, just remember to manually remove any QCUBED_OFFSET<#> information.

ENHANCEMENTS over MSSQL based-driver: - varchar limit of 254 characters no longer exists, uses full varchar(8000) - supports different date formats - faster

DATE VALUES: If the date format of your database is different from the standard english format of 'YYYY-MM-DD hhhh:mm:ss' you have to declare it by setting the option 'dateformat' in the database connection array in the configuration.inc.php. For instance if your database wants german date settings you would set it to 'DD.MM.YYYY hhhh:mm:ss'.

LIMITATIONS: - GROUP BY Using GROUP BY clause is broken because: a) Current QQuery implementation is MySQL specific. Standard SQL wants every column in the SELECT statement, that is not an aggregate statement, in the GROUP BY clause and this behaviour is currently not supported. This limitation is valid too for the MSSQL based adapter.

Datatypes currently not fully supported sql_variant, varbinary(max), geometry, geography, hierarchyid, uniqueidentifier

QBaseClass

QDatabaseBase

QSqlServer2005Database

Package: DatabaseAdapters
Copyright: Copyright (C) 2009,2010 Andreas Krohn
License: http://www.opensource.org/licenses/mit-license.php
Author: Andreas Krohn akrohn.pronet@googlemail.com, based on code by Mike Ho
Located at includes/database/QSqlServer2005Database.class.php

Methods summary
`public string`	# `SqlVariable( mixed $mixData, boolean $blnIncludeEquality = false, boolean $blnReverseEquality = false )` Properly escapes $mixData to be used as a SQL query parameter. If IncludeEquality is set (usually not), then include an equality operator. So for most data, it would just be "=". But, for example, if $mixData is NULL, then most RDBMS's require the use of "IS". Properly escapes $mixData to be used as a SQL query parameter. If IncludeEquality is set (usually not), then include an equality operator. So for most data, it would just be "=". But, for example, if $mixData is NULL, then most RDBMS's require the use of "IS". Parameters `$mixData` `$blnIncludeEquality` whether or not to include an equality operator `$blnReverseEquality` whether the included equality operator should be a "NOT EQUAL", e.g. "!=" Returns string the properly formatted SQL variable Overrides `QDatabaseBase::SqlVariable()`
`public`	# `SqlLimitVariablePrefix( $strLimitInfo )`
`public`	# `SqlLimitVariableSuffix( $strLimitInfo )`
`public`	# `SqlSortByVariable( $strSortByInfo )`
`public`	# `Connect( )` Connects to the database Connects to the database
`public mixed`	# `__get( string $strName )` PHP magic method PHP magic method Parameters `$strName` Property name Returns mixed Throws Exception\|`QCallerException` Overrides `QDatabaseBase::__get()`
`protected mixed`	# `ExecuteQuery( string $strQuery )` Sends a SQL query for execution to the database In this regard, a query is a 'SELECT' statement Sends a SQL query for execution to the database In this regard, a query is a 'SELECT' statement Parameters `$strQuery` The Query to be executed Returns mixed Result that the database returns after running the query.
`protected mixed`	# `ExecuteNonQuery( string $strNonQuery )` Sends a non-SELECT query (such as INSERT, UPDATE, DELETE, TRUNCATE) to DB server. In most cases, the results of this function are not used and you should not send 'SELECT' queries using this method because a result is not guaranteed to be returned Sends a non-SELECT query (such as INSERT, UPDATE, DELETE, TRUNCATE) to DB server. In most cases, the results of this function are not used and you should not send 'SELECT' queries using this method because a result is not guaranteed to be returned If there was an error, it would most probably be caught as an exception. Parameters `$strNonQuery` The Query to be executed Returns mixed Result that the database returns after running the query
`public mixed\|string[]`	# `GetTables( )` Returns the list of tables in the database (as string) Returns the list of tables in the database (as string) Returns mixed\|string[] List of tables
`public`	# `GetTableForId( $intTableId )`
`public mixed`	# `GetFieldsForTable( string $strTableName )` Get the list of columns/fields for a given table Get the list of columns/fields for a given table Parameters `$strTableName` Name of table whose fields we have to get Returns mixed
`public mixed`	# `InsertId( null\|string $strTableName = null, null\|string $strColumnName = null )` Returns the ID to be inserted in a table column (normally it an autoincrement column) Returns the ID to be inserted in a table column (normally it an autoincrement column) Parameters `$strTableName` Table name where the ID has to be inserted `$strColumnName` Column name where the ID has to be inserted Returns mixed
`public mixed`	# `Close( )` Closes the database connection Closes the database connection Returns mixed
`protected`	# `ExecuteTransactionBegin( )` Begin transaction Begin transaction Returns Nothing
`protected`	# `ExecuteTransactionCommit( )` Commit transaction Commit transaction Returns Nothing
`protected`	# `ExecuteTransactionRollBack( )` Rollback transaction Rollback transaction Returns Nothing
`public mixed`	# `GetIndexesForTable( string $strTableName )` Get list of indexes for a table Get list of indexes for a table Parameters `$strTableName` Name of table whose column indexes we have to get Returns mixed
`public mixed`	# `GetForeignKeysForTable( string $strTableName )` Get list of foreign keys for a table Get list of foreign keys for a table Parameters `$strTableName` Name of table whose foreign keys we are trying to get Returns mixed

Methods inherited from QDatabaseBase
`EnableProfiling(), EscapeIdentifier(), EscapeIdentifiers(), EscapeIdentifiersAndValues(), EscapeValues(), ExecuteProcedure(), ExplainStatement(), ExtractCommentOptions(), InsertOrUpdate(), NonQuery(), OutputProfiling(), PrepareStatement(), Query(), TransactionBegin(), TransactionCommit(), TransactionRollBack(), __construct(), __set(), transactionCacheFlush(), transactionCacheRestore()`

Methods inherited from QBaseClass
`OverrideAttributes(), __call()`

Constants inherited from QDatabaseBase
`Adapter`

Properties summary
`protected`	`$objSqlSrvConn`	#
`protected`	`$objMostRecentStatement`	#
`protected string`	`$strEscapeIdentifierBegin` The beginning part of characters which can escape identifiers in a SQL query for the database The beginning part of characters which can escape identifiers in a SQL query for the database	# `'['`
`protected string`	`$strEscapeIdentifierEnd` The ending part of characters which can escape identifiers in a SQL query for the database The ending part of characters which can escape identifiers in a SQL query for the database	# `']'`
`protected boolean`	`$blnOnlyFullGroupBy`	# `true`
`protected array`	`$mixedOptionsArray`	# `array( )`

Properties inherited from QDatabaseBase
`$blnConnectedFlag, $blnEnableProfiling, $intDatabaseIndex, $intTransactionDepth, $objCacheProviderStack, $objConfigArray, $strProfileArray`

Magic properties inherited from QDatabaseBase
`$Adapter, $AffectedRows, $Caching, $Database, $DatabaseIndex, $DateFormat, $EnableProfiling, $EscapeIdentifierBegin, $EscapeIdentifierEnd, $Host, $OnlyFullGroupBy, $Password, $Port, $Profile, $Protocol, $Server, $Service, $Username`

Packages

Classes

Exceptions

Class QSqlServer2005Database

Parameters

Returns

Overrides

Parameters

Returns

Throws

Overrides

Parameters

Returns

Parameters

Returns

Returns

Parameters

Returns

Parameters

Returns

Returns

Returns

Returns

Returns

Parameters

Returns

Parameters

Returns