Select * from sys.servers

sp_get_serverinfo

select @@version

sp_serverproperty

Atomicity,Concurrently,Isolation,Durability

Atomicity,Consistency,Incremental,Durability

Atomicity,Consistency,Isolation and Durability

Atomicity,Concurrently,Incremental,Durability

True

False

Intent

Shared

Exclusive

Delete

Read Uncommitted

Read Committed

Serializable

Repeatable Read

True

False

10.5.1702

8.00.223

9.00.4285

7.00.1152

Subqueries can have up to 16 levels of nesting

Subqueries can have up to 50 levels of nesting

Subqueries returning only one row can follow “=” in a WHERE clause

Subqueries returning only one row can follow “IN” in a WHERE clause

Outer joins

Multi-table updates and deletes

Equi-joins

Equi-join with a text column in select list

All select lists in the UNION must have the same number of expressions

Corresponding columns must have the same column names

Corresponding columns must be of the same datatype or the server must be able to implicitly convert them

Corresponding columns must be in the same order

Duplicate rows are removed from the result set by default

ASE evaluates a statement containing union operators from left to right

Order by and group by clauses are not allowed in a union query

The into clause can be used only in the first query

the inserted and deleted tables are created manually

triggers can be disabled using alter table

a single trigger can be created for both insert and delete

@@sqlstatus contains the number of rows affected

0

1

2

3

'return', without a return value

'rollback transaction'

'rollback trigger'

the built-in function 'update()'

sysprocedures

syscomments

syslogs

systext

127

255

16384

equal to the server page size

insert

update

insert, update, delete

delete,update

Index

Cluster

Package

DB links

Function

Package

Function

Procedure

Another DB trigger

Trigger type

Trigger body

Trigger event

Trigger timing