Öffentliche Methoden |
|
| ADODB_odbc_mssql () |
|
| ServerInfo () |
|
| IfNull ($field, $ifNull) |
|
| _insertid () |
|
| MetaForeignKeys ($table, $owner=false, $upper=false) |
|
| MetaTables ($ttype=false, $showSchema=false, $mask=false) |
|
| MetaColumns ($table, $normalize=true) |
|
| MetaIndexes ($table, $primary=false, $owner=false) |
|
| _query ($sql, $inputarr=false) |
|
| SetTransactionMode ($transaction_mode) |
|
| MetaPrimaryKeys ($table) |
|
| SelectLimit ($sql, $nrows=-1, $offset=-1, $inputarr=false, $secs2cache=0) |
|
| SQLDate ($fmt, $col=false) |
Datenfelder |
|
| $databaseType = 'odbc_mssql' |
|
| $fmtDate = "'Y-m-d'" |
|
| $fmtTimeStamp = "'Y-m-d H:i:s'" |
|
| $_bindInputArray = true |
|
| $metaDatabasesSQL = "select name from sysdatabases where name <> 'master'" |
|
| $metaTablesSQL = "select name,case when type='U' then 'T' else 'V' end from sysobjects where (type='U' or type='V') and (name not in ('sysallocations','syscolumns','syscomments','sysdepends','sysfilegroups','sysfiles','sysfiles1','sysforeignkeys','sysfulltextcatalogs','sysindexes','sysindexkeys','sysmembers','sysobjects','syspermissions','sysprotects','sysreferences','systypes','sysusers','sysalternates','sysconstraints','syssegments','REFERENTIAL_CONSTRAINTS','CHECK_CONSTRAINTS','CONSTRAINT_TABLE_USAGE','CONSTRAINT_COLUMN_USAGE','VIEWS','VIEW_TABLE_USAGE','VIEW_COLUMN_USAGE','SCHEMATA','TABLES','TABLE_CONSTRAINTS','TABLE_PRIVILEGES','COLUMNS','COLUMN_DOMAIN_USAGE','COLUMN_PRIVILEGES','DOMAINS','DOMAIN_CONSTRAINTS','KEY_COLUMN_USAGE'))" |
|
| $metaColumnsSQL = "select c.name,t.name,c.length from syscolumns c join systypes t on t.xusertype=c.xusertype join sysobjects o on o.id=c.id where o.name='%s'" |
|
| $hasTop = 'top' |
|
| $sysDate = 'GetDate()' |
|
| $sysTimeStamp = 'GetDate()' |
|
| $leftOuter = '*=' |
|
| $rightOuter = '=*' |
|
| $substr = 'substring' |
|
| $length = 'len' |
|
| $ansiOuter = true |
|
| $identitySQL = 'select SCOPE_IDENTITY()' |
|
| $hasInsertID = true |
|
| $connectStmt = 'SET CONCAT_NULL_YIELDS_NULL OFF' |
Definiert in Zeile 23 der Datei adodb-odbc_mssql.inc.php.
