Chapter 1: Quick Reference  Adaptive Server global variables

Chapter 1: Quick Reference

Standards and compliance

This table lists the ANSI SQL standards and compliance levels for Transact-SQL datatypes. See Reference Manual: Building Blocks for more information about standards and compliance.

Transact-SQL – ANSI SQL datatypes

Transact-SQL extensions – User-defined datatypes

  • char

  • varchar

  • smallint

  • int

  • bigint

  • decimal

  • numeric

  • float

  • real

  • date

  • time

  • double precision

  • binary

  • varbinary

  • bit

  • nchar

  • datetime

  • smalldatetime

  • tinyint

  • unsigned smallint

  • unsigned int

  • unsigned bigint

  • money

  • smallmoney

  • text

  • unitext

  • image

  • nvarchar

  • unichar

  • univarchar

  • sysname

  • longsysname

  • timestamp



Copyright © 2005. Sybase Inc. All rights reserved. Adaptive Server global variables

View this book as PDF