Values for sp_capabilities

sp_capabilities values.

Capability Number

Capability

Description

101

SQL syntax

  • 1 – Sybase supported

  • 2 – DB2 UDB supported

102

Join handling

  • 0 – unsupported

  • 1 – all but outer join supported

  • 2 – full join supported

103

Aggregate handling

  • 0 – unsupported

  • 1 – count not supported

  • 2 – all functions

104

AND predicates

  • 0 – unsupported

  • 1 – supported

105

OR predicates

  • 0 – unsupported

  • 1 – supported

106

LIKE predicates

  • 0 – unsupported

  • 1 – ANSI supported

  • 2 – Sybase supported

107

Bulk insert handling

  • 0 – unsupported

  • 1 – supported

108

Text/image handling

  • 0 – unsupported

  • 1 – text without textptr supported

  • 2 – text with textptr supported

109

Transaction handling

  • 0 – unsupported

  • 1 – local supported

  • 2 – two-phase-commit supported

110

Text pattern handling

  • 0 – unsupported

  • 1 – supported

111

Order by

  • 0 – unsupported

  • 1 – supported

112

Group by

  • 0 – unsupported

  • 1 – supported

113

Net password encryption

  • 0 – unsupported

  • 1 – supported

114

Object case sensitivity

  • 0 – not case-sensitive

  • 1 – case-sensitive

115

Distinct

  • 0 – unsupported

  • 1 – supported

116

Wildcard escape

  • 0 – unsupported

  • Anything else is the escape character

117

Union handling

  • 0 – unsupported

  • 1 – supported

118

String functions

  • 0 – unsupported

  • 1 – substring supported

  • 2 – Oracle subset supported

  • 3 – all Transact-SQL supported

119

Expression handling

  • 0 – unsupported

  • 1 – supported

  • 2 – full Transact-SQL supported

120

Truncate trailing spaces on varchar/char CSP parameters

  • 0 – no

  • 1 – yes

121

Language events

  • 0 – no support for DML

  • 1 – DML support without datetime in where clause

  • 2 – no restrictions on DML

122

Date functions

  • 0 – unsupported

  • 1 – all Transact-SQL supported

123

Math functions

  • 0 – unsupported

  • 1 – Oracle subset supported

  • 2 – all Transact-SQL supported

124

Transact-SQL convert function

  • 0 – unsupported

  • 1 – supported

125

Transact-SQL delete/update

  • 0 – unsupported

  • 1 – Transact-SQL extensions supported

126

Insert/update handling

  • 0 – unsupported

  • 1 – supported

127

Subquery handling

  • 0 – unsupported

  • 1 – supported

128

In/not in clause

  • 0 – unsupported

  • 1 – supported

129

Case expression in a SQL statement

  • 0 – unsupported

  • 1 – supported

132

Tables per statement

  • 0 – unsupported

  • 1 – supported

133

Java UDF support

  • 0 – unsupported

  • 1 – supported

134

Java ADT support

  • 0 – unsupported

  • 1 – supported

135

Quoted Identifier support

  • 0 – unsupported

  • 1 – supported

137

SELECT-NULL support

  • 0 – unsupported

  • 1 – supported

138

Identity column support

  • 0 – unsupported

  • 1 – supported
Parent topic: sp_capabilities