|
|
|
|
|
This document describes the differences in T-SQL dialect between Sybase ASE 12.5.3 and MS SQL Server 2008 R2. From now on, instead of ‘Sybase ASE 12.5.3’, the abbreviated form 'ASE' is used, and instead of ‘MS SQL Server 2008 R2’, 'MS SQL Server' is used.
This document is written from the viewpoint of an ASE T-SQL programmer. Therefore, the document lists language elements that are present in ASE, but that do not exist in MS SQL Server. Also, constructions are described that behave differently in some situations. New language elements in MS SQL Server are beyond the scope of this document. This document is meant to assist T-SQL programmers when rewriting their code. It is not meant as an MS SQL Server T-SQL course.
Quite a few of the ASE functions that do not exist in MS SQL Server, have to do with DBA tasks. Most T-SQL programmers will not use these functions. The syntax and the use of these functions in ASE are explained, so a programmer can decide on the basis of this description if this information is useful to her or to him.
In chapters Differences In T-SQL Dialects and Differences In Function Behavior the differences in T-SQL dialects are described. Chapter ASE Functions That Do Not Exist In MS SQL Server and ASE TSQL Constructions That Do Not Exist In MS SQL Server contains lists of constructions and functions that are not present in MS SQL Server. The first two chapters are the more important ones. The topics described in these chapters are not listed in order of relevance. Instead, topics were grouped by construction.
Note: This document does not contain all differences between ASE and MS SQL Server.