class DBMSSQL extends DBAdapter
This is used to connect to a MSSQL database.
Constants
ID_METHOD_NONE |
|
ID_METHOD_AUTOINCREMENT |
|
ID_METHOD_SEQUENCE |
|
Methods
static DBAdapter |
factory(string $driver)
Creates a new instance of the database adapter associated with the specified Propel driver. |
from DBAdapter | |||||||||||||||
array |
prepareParams(array $settings)
Prepare connection parameters. |
from DBAdapter | |||||||||||||||
initConnection(PDO $con, array $settings)
This method is called after a connection was created to run necessary post-initialization queries or code. |
from DBAdapter | ||||||||||||||||
setCharset(PDO $con, string $charset)
MS SQL Server does not support SET NAMES |
|||||||||||||||||
string |
toUpperCase(string $in)
This method is used to ignore case. |
||||||||||||||||
string |
getStringDelimiter()
Returns the character used to indicate the beginning and end of a piece of text used in a SQL statement (generally a single quote). |
from DBAdapter | |||||||||||||||
string |
ignoreCase(string $in)
This method is used to ignore case. |
||||||||||||||||
string |
ignoreCaseInOrderBy(string $in)
This method is used to ignore case in an ORDER BY clause. |
from DBAdapter | |||||||||||||||
string |
concatString(string $s1, string $s2)
Returns SQL which concatenates the second string to the first. |
||||||||||||||||
string |
subString(string $s, integer $pos, integer $len)
Returns SQL which extracts a substring. |
||||||||||||||||
string |
strLength(string $s)
Returns SQL which calculates the length (in chars) of a string. |
||||||||||||||||
string |
quoteIdentifier(string $text)
|
||||||||||||||||
string |
quoteIdentifierTable(string $table)
|
||||||||||||||||
boolean |
isGetIdBeforeInsert()
Whether this adapter uses an ID generation system that requires getting ID before performing INSERT. |
from DBAdapter | |||||||||||||||
boolean |
isGetIdAfterInsert()
Whether this adapter uses an ID generation system that requires getting ID before performing INSERT. |
from DBAdapter | |||||||||||||||
mixed |
getId(PDO $con, string $name = null)
Gets the generated ID (either last ID for autoincrement or next sequence ID). |
from DBAdapter | |||||||||||||||
string |
formatTemporalValue(mixed $value, mixed $type)
Formats a temporal value before binding, given a ColumnMap object. |
from DBAdapter | |||||||||||||||
string |
getTimestampFormatter()
Returns timestamp formatter string for use in date() function. |
from DBAdapter | |||||||||||||||
string |
getDateFormatter()
Returns date formatter string for use in date() function. |
from DBAdapter | |||||||||||||||
string |
getTimeFormatter()
Returns time formatter string for use in date() function. |
from DBAdapter | |||||||||||||||
useQuoteIdentifier()
Should Column-Names get identifiers for inserts or updates. |
from DBAdapter | ||||||||||||||||
cleanupSQL(string $sql, array $params, Criteria $values, DatabaseMap $dbMap)
|
|||||||||||||||||
void |
applyLimit(string $sql, integer $offset, integer $limit)
Simulated Limit/Offset |
||||||||||||||||
string |
random(string $seed = null)
|
||||||||||||||||
string |
getDeleteFromClause(Criteria $criteria, string $tableName)
Returns the "DELETE FROM
Details
|