Show Menu
Cheatography

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")

REGEXP search condition

SELECT * FROM table-name
WHERE col-name REGEXP 'reg-expr';
Example:
SELECT Surname, Surname, City, Phone FROM Contacts WHERE Phone REGEXP '\\d{8­}00';

REGEXP­_SUBSTR function

SELECT REGEXP_SUBSTR( col-name, 'reg-expr' )
FROM table-name;
Example:
SELECT REGEXP­_SU­BSTR( Street, '(?<=^­\\S­+\­\s+).*$' ) FROM Custom­ers;
                   

Help Us Go Positive!

We offset our carbon usage with Ecologi. Click the link below to help us!

We offset our carbon footprint via Ecologi
 

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