Archive for the ‘T-SQL’ Category

Intro to Transact-SQL (T-SQL)

Thursday, April 30th, 2009

Transact-SQL (T-SQL) is an extension of the SQL standards by Sybase and Microsoft and includes error handling, row processing and variable declaration.

Usage:
You can programs (stored procedures) on the database server and thus extend the database functionality, each user of the database can call up these programs and use. The permissions may be established for each Transact-SQL procedure to an individual user basis.

External links:

  1. Transact-SQL Reference by Microsoft for MS-SQL 2008
  2. Transact-SQL Reference for Sybase Adaptive Server Enterprise 12.5.1
  3. T-SQL Factsheet for developers as PDF