SQLAnywhere: Watcom SQL or T-SQL

The general question. I am developing for Sybase SQL Anywhere 10. For backward compatibility purposes, almost all of our stored procedures are written in Transact-SQL. Are there any advantages or disadvantages to using T-SQL instead of the Watcom dialect?

+5
source share
3 answers

TSQL Benefits:

  • Greater compatibility with Sybase ASE and Microsoft SQL Server

TSQL disadvantages:

  • some operators and functions are only available in Watcom-SQL procedures. Some examples:
    • more control over EXECUTE IMMEDIATE behavior in Watcom-SQL
    • LOAD TABLE, UNLOAD TABLE, REORGANIZE (among others) are only available in Watcom-SQL
    • FOR , , , TSQL
  • , , TSQL , Watcom-SQL . Watcom-SQL EXCEPTION .
  • , TSQL ( ). .
  • TSQL
  • Watcom-SQL

SQL Anywhere T-SQL . , Sybase ASE. , , .

, Watcom , SP , Watcom. SP, .

+6

KM - , "Watcom" SQL/ANSI, , , , SQL.

+3

If you are ever trying to migrate to SQL Server (or you are going to work on SQL Server), Sybase T-SQL is very close to the T-SQL SQL server. Sybase and MS came together during the day, so the core of these languages ​​is very similar.

+1
source

All Articles