TMssqlCommandBuilder provides specifics methods to create limit/offset query commands for MSSQL servers.
Located in /Data/Common/Mssql/TMssqlCommandBuilder.php (line 24)
TComponent | --TDbCommandBuilder | --TMssqlCommandBuilder
Overrides parent implementation. Alters the sql to apply $limit and $offset.
The idea for limit with offset is done by modifying the sql on the fly with numerous assumptions on the structure of the sql string. The modification is done with reference to the notes from http://troels.arvin.dk/db/rdbms/#select-limit-offset
Regular expressions are used to alter the SQL query. The resulting SQL query may be malformed for complex queries. The following restrictions apply
Base on simplified syntax http://msdn2.microsoft.com/en-us/library/aa259187(SQL.80).aspx
Overrides parent implementation. Uses "SELECT @@Identity".
Rewrite sql to apply $limit > and $offset > 0 for MSSQL database.
See http://troels.arvin.dk/db/rdbms/#select-limit-offset
Inherited From TDbCommandBuilder
TDbCommandBuilder::__construct()
TDbCommandBuilder::applyCriterias()
TDbCommandBuilder::applyLimitOffset()
TDbCommandBuilder::applyOrdering()
TDbCommandBuilder::bindArrayValues()
TDbCommandBuilder::bindColumnValues()
TDbCommandBuilder::createCommand()
TDbCommandBuilder::createCountCommand()
TDbCommandBuilder::createDeleteCommand()
TDbCommandBuilder::createFindCommand()
TDbCommandBuilder::createInsertCommand()
TDbCommandBuilder::createUpdateCommand()
TDbCommandBuilder::getColumnBindings()
TDbCommandBuilder::getDbConnection()
TDbCommandBuilder::getInsertFieldBindings()
TDbCommandBuilder::getLastInsertID()
TDbCommandBuilder::getPdoType()
TDbCommandBuilder::getSearchCondition()
TDbCommandBuilder::getSearchExpression()
TDbCommandBuilder::getTableInfo()
TDbCommandBuilder::hasIntegerKey()
TDbCommandBuilder::setDbConnection()
TDbCommandBuilder::setTableInfo()
Inherited From TComponent
TComponent::addParsedObject()
TComponent::attachEventHandler()
TComponent::canGetProperty()
TComponent::canSetProperty()
TComponent::createdOnTemplate()
TComponent::detachEventHandler()
TComponent::evaluateExpression()
TComponent::evaluateStatements()
TComponent::getEventHandlers()
TComponent::getSubProperty()
TComponent::hasEvent()
TComponent::hasEventHandler()
TComponent::hasProperty()
TComponent::raiseEvent()
TComponent::setSubProperty()
TComponent::__get()
TComponent::__set()
Documentation generated on Mon, 21 Apr 2008 11:35:37 -0400 by phpDocumentor 1.3.0RC4