ADODB_odbc_mssql Class Reference

Inheritance diagram for ADODB_odbc_mssql:

Collaboration diagram for ADODB_odbc_mssql:

Public Member Functions
	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)
Data Fields
	$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'

---

Detailed Description

Definition at line 23 of file adodb-odbc_mssql.inc.php.

---

Member Function Documentation

_insertid

(

)

Definition at line 69 of file adodb-odbc_mssql.inc.php.

_query	(	$	sql,
		$	inputarr = false
	)

Reimplemented from ADODB_odbc.

Definition at line 181 of file adodb-odbc_mssql.inc.php.

ADODB_odbc_mssql

(

)

Definition at line 44 of file adodb-odbc_mssql.inc.php.

Here is the call graph for this function:

IfNull	(	$	field,
		$	ifNull
	)

Definition at line 64 of file adodb-odbc_mssql.inc.php.

MetaColumns	(	$	table,
		$	normalize = true
	)

Reimplemented from ADODB_odbc.

Definition at line 134 of file adodb-odbc_mssql.inc.php.

MetaForeignKeys	(	$	table,
		$	owner = false,
		$	upper = false
	)

Definition at line 80 of file adodb-odbc_mssql.inc.php.

MetaIndexes	(	$	table,
		$	primary = false,
		$	owner = false
	)

Definition at line 141 of file adodb-odbc_mssql.inc.php.

MetaPrimaryKeys

(

$

table

)

Reimplemented from ADODB_odbc.

Definition at line 200 of file adodb-odbc_mssql.inc.php.

MetaTables	(	$	ttype = false,
		$	showSchema = false,
		$	mask = false
	)

Definition at line 119 of file adodb-odbc_mssql.inc.php.

SelectLimit	(	$	sql,
		$	nrows = -1,
		$	offset = -1,
		$	inputarr = false,
		$	secs2cache = 0
	)

Definition at line 224 of file adodb-odbc_mssql.inc.php.

ServerInfo

(

)

Reimplemented from ADODB_odbc.

Definition at line 51 of file adodb-odbc_mssql.inc.php.

SetTransactionMode

(

$

transaction_mode

)

Definition at line 187 of file adodb-odbc_mssql.inc.php.

SQLDate	(	$	fmt,
		$	col = false
	)

Definition at line 237 of file adodb-odbc_mssql.inc.php.

---

Field Documentation

$_bindInputArray = true

Reimplemented from ADODB_odbc.

Definition at line 27 of file adodb-odbc_mssql.inc.php.

$ansiOuter = true

Definition at line 38 of file adodb-odbc_mssql.inc.php.

$connectStmt = 'SET CONCAT_NULL_YIELDS_NULL OFF'

Definition at line 41 of file adodb-odbc_mssql.inc.php.

$databaseType = 'odbc_mssql'

Reimplemented from ADODB_odbc.

Definition at line 24 of file adodb-odbc_mssql.inc.php.

$fmtDate = "'Y-m-d'"

Reimplemented from ADODB_odbc.

Definition at line 25 of file adodb-odbc_mssql.inc.php.

$fmtTimeStamp = "'Y-m-d H:i:s'"

Reimplemented from ADODB_odbc.

Definition at line 26 of file adodb-odbc_mssql.inc.php.

$hasInsertID = true

Definition at line 40 of file adodb-odbc_mssql.inc.php.

$hasTop = 'top'

Definition at line 31 of file adodb-odbc_mssql.inc.php.

$identitySQL = 'select SCOPE_IDENTITY()'

Definition at line 39 of file adodb-odbc_mssql.inc.php.

$leftOuter = '*='

Definition at line 34 of file adodb-odbc_mssql.inc.php.

$length = 'len'

Definition at line 37 of file adodb-odbc_mssql.inc.php.

$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'"

Definition at line 30 of file adodb-odbc_mssql.inc.php.

$metaDatabasesSQL = "select name from sysdatabases where name <> 'master'"

Definition at line 28 of file adodb-odbc_mssql.inc.php.

$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'))"

Definition at line 29 of file adodb-odbc_mssql.inc.php.

$rightOuter = '=*'

Definition at line 35 of file adodb-odbc_mssql.inc.php.

$substr = 'substring'

Definition at line 36 of file adodb-odbc_mssql.inc.php.

$sysDate = 'GetDate()'

Definition at line 32 of file adodb-odbc_mssql.inc.php.

$sysTimeStamp = 'GetDate()'

Definition at line 33 of file adodb-odbc_mssql.inc.php.

---

The documentation for this class was generated from the following file:

• C:/xampp/htdocs/moodle/lib/adodb/drivers/adodb-odbc_mssql.inc.php