Show Menu

Sybase Cheat Sheet by

database     server     sap     sybase     sqlanywhere

Sybase Data Types

TINYINT
Integer (0 to 255)
SMALLINT
Integer (-32768 to +32767)
INT
Integer (-2147­483648 to +21474­83647)
BIGINT
Integer (-9233­372­036­854­775808 to +92333­720­368­547­75807)
DECIMAL
Decimal (-1038 and 1038 -1)
NUMERIC
Decimal (-1038 and 1038 -1)
FLOAT
Decimal (8 byte, machin­e-d­epe­ndent)
REAL
Decimal (4 byte, machin­e-d­epe­ndent)
CHAR(n)
String (1 to 255)
NCHAR(n)
String (1 to 255)
VARCHAR(n)
String (1 to 255)
NVARCH­AR(n)
String (1 to 255)
TEXT
String (2^31 charac­ters)
MONEY
Decimal (92233­720­368­547­7.5807 to -92233­720­368­547­7.5808)
SMALLMONEY
Decimal (21474­8.3647 to -21474­8.3648)
DATE
Date (1753-­01-01 to 9999-1­2-31)
DATETIME
DateTime (1753-­01-01 to 9999-1­2-31)
SMALLD­ATETIME
DateTime (1900-­01-01 to 2079-0­6-06)
TIME
Time (12:00­:00AM to 11:59:­59:­999PM)
TIMESTAMP
Timestamp
BIGTIME
Time (12:00­:00.000000 AM to 11:59:­59.9­99999 PM)
BIGDAT­ETIME
DateTime (0001-­01-01 to 9999-12-31 and 12:00.0­00­000AM to 11:59:­59.9­99999 PM)
BIT
Boolean (0 or 1)
BINARY
Binary (0 - 256 bytes)
VARBINARY
Binary (0 - 255 bytes)
IMAGE
Blob (Binary 231)
 

CASE Statement

CASE value-expression
  WHEN [constant | NULL] THEN statement-list …
  [ WHEN [constant | NULL] THEN statement-list ] …
  ELSE statement-list
END

IF Statement

IF condition THEN expression
[ELSE expression]
END [IF]

Local variables

DECLARE @c1 FLOAT, @c2 FLOAT
SELECT @c1 = 1000/1000
SELECT @c2 = @c1/30
SELECT @c1 , @c

LIST function [Aggre­gate]

LIST (
  [ALL | DISTINCT] string-expr
  [, 'delimiter-string']
  [ORDER BY order-by-expr [ ASC | DESC ], ... ]
)
Example:
SELECT LIST(E­mpl­oyeeID) FROM Employees GROUP BY Depart­mentID

sa_spl­it_list system procedure

Takes a string of values, separated by a delimiter, and returns a set of rows—one row for each value.
sa_sp­lit­_list( str [, delim ] [, maxlen ])
Result set:
line_num Sequential number for the row.
row_v­alue Value from the string, truncated to maxlen if required.

Local Temporary Table

DROP TABLE IF EXISTS table-name
DECLARE LOCAL TEMPORARY TABLE table-name
… ( col-name [ col-constraint ] …
[ , col-name [ col-constraint ] … ]
[ , table-constraint ] … )
…[ ON COMMIT { DELETE | PRESERVE } ROWS NOT TRANSACTIONAL]
Push data to temp table
INSERT INTO table-name SELECT ... or
SELECT * INTO table-name FROM ...
 

DatePart abbrev­ations

date­part
abbr
values
year
yy
1753–9999 (datetime) 1753–2079 (small­dat­etime) 0001–9999 (bigda­tetime)
quarter
qq
1-4
month
mm
1-12
week
wk
1-54
day
dd
1-31
dayofyear
dy
1-366
weekday
dw
1–7 (Sun. – Sat.)
hour
hh
0-23
minute
mi
0-59
second
ss
0-59
millis­econd
ms
0-999
micros­econds
us
0-999999

DateAdd

DATEADD(date-part, value, timestamp)
Example: add 102 months to the date
SELECT DATEAD­D(m­onth, 102, '1987/­05/­02')

DateDiff

DATEDIFF(datepart, {date, date | time, time | bigtime, bigtime | datetime, datetime | bigdatetime, bigdatetime}])
Example: hours between two dates
SELECT DATEDI­FF(hh, "apr 1, 1999", "apr 2, 1999")

Download the Sybase Cheat Sheet

2 Pages
//media.cheatography.com/storage/thumb/pxlcore_sybase.750.jpg

PDF (recommended)

Alternative Downloads

Share This Cheat Sheet!

Like this cheat sheet? Check out our sponsors!

Readable.io is a collection of tools to make your writing better. More readable content means higher conversion rates and better reader engagement. Measure website and document readability, measure keyword density and more!

Click Here To Get Started!

 

Comments

No comments yet. Add yours below!

Add a Comment

Your Comment

Please enter your name.

    Please enter your email address

      Please enter your Comment.

          Related Cheat Sheets

          MySQL Cheat Sheet
          SQL Server Cheat Sheet