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!

 

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