Category: ASE: Functions

T-SQL Functions, Transact-SQL Functions, Functions

The functions available in ASE provide a possibility to query and display data from a database They can be used in select statements, in where clauses and whereever so-called expressions are allowed and can be used. Often these functions are used to create stored procedures or programmes.

Types of functions

ASE provides the following types of functions with different tasks:

• Aggregate Functions - These functions create a context of values which can be stored in a seperate column or displayed in a seperate row.
• Datatype Conversion Functions - These functions are able to modify datatypes. They can set another output format for date and time datatypes.
• Date & Time Functions - These functions calculate values of the datatypes datetime, smalldatetime, date and time.
• Mathematical Functions - These functions are used for mathematical calculations.
• Security Functions - Functions for security relevant information.
• User, Login and Role Functions - These functions display user, login and role specific information.
• String Functions - These functions can be used for binary data and arbitrary character strings.
• System Functions - These functions show system relevant information for databases and objects .
• Text & Image Functions - These functions are used for queries on the datatypes text and image.

ASE® functions - an overview

Aggregate Functions

• avg()
• count_big()
• count(*)
• count()
• max()
• min()
• sum()

Datatype Conversion Functions

• biginttohex()
• bintostr()
• cast()
• convert()
• hextoint()
• hextobigint()
• inttohex()
• strtobin()

Date and Time Functions

• convert() (siehe auch: Style-Nummern)
• dateadd()
• datediff()
• datename()
• datepart()
• getdate()
• year()
• month()
• day()

Mathematical Functions

• abs()
• acos()
• asin()
• atan()
• atn2()
• ceiling()
• cos()
• cot()
• degrees()
• exp()
• floor()
• log()
• log10()
• pi()
• power()
• radians()
• rand()
• round()
• sign()
• sin()
• sqrt()
• tan()

Security Functions

• is_sec_service_on()
• get_appcontext()
• list_appcontext()
• rm_appcontext()
• show_sec_services()
• set_appcontext()

User, Login and Role Functions

• has_role()
• mut_excl_roles()
• proc_role()
• role_contain()
• role_id()
• role_name()
• show_role()
• suser_id()
• suser_name()
• user
• user_id()
• user_name()
• valid_user()

String Functions

• ascii()
• char()
• charindex()
• char_length()
• compare()
• difference()
• lower()
• ltrim()
• patindex()
• replicate()
• reverse()
• right()
• rtrim()
• sortkey()
• soundex()
• space()
• str()
• stuff()
• substring()
• to_unichar()
• uhighsurr()
• ulowsurr()
• upper()
• uscalar()
• valid_name()

System Functions

• col_length()
• col_name()
• curunreservedpgs()
• data_pages()
• data_pgs()
• datalength()
• db_id()
• db_name()
• host_id()
• host_name()
• identity_burn_max()
• index_col()
• index_colorder()
• is_quiesced()
• isnull()
• lct_admin()
• license_enable()
• lockscheme()
• object_id()
• object_name()
• pagesize()
• pointer_size()
• pnt_data_pgs()
• reserved_pages()
• reserved_pgs()
• row_count()
• rowcnt()
• syb_quit()
• syb_sendmsg()
• tempdb_id()
• tran_dumptable_status()
• tsequal()
• used_pages()
• used_pgs()

See also:

ASE T-SQL - Aggregate Functions,
Mathematical Functions,
abs(),
acos(),
ascii(),
ASE T-SQL - User,
asin(),
atan(),
atn2(),
audit_event_name(),
avg(),
biginttohex(),
bintostr(),
cast(),
ceiling(),
char(),
char(n),
charindex(),
char_length(),
col_length(),
col_name(),
compare(),
convert(),
cos(),
cot(),
count(*),
count(),
count_big(),
curunreservedpgs(),
datachange(),
datalength(),
Datatype Conversion Functions,
data_pages(),
data_pgs(),
Date and Time Functions,
dateadd(),
datediff(),
datename(),
datepart(),
date_part,
day(),
db_id(),
db_name(),
degrees(),
difference(),
exp(),
explicit conversion,
floor(),
getdate(),
get_appcontext(),
hextobigint(),
hextoint(),
host_id(),
host_name(),
identity(),
implicit conversions,
index_col(),
index_colorder(),
inttohex(),
isnull(),
is_sec_service_on(),
lct_admin(),
license_enabled(),
list_appcontext(),
lockscheme(),
log(),
log10(),
lower(),
ltrim(),
max(),
min(),
month(),
mut_excl_roles(),
next_identity(),
object_id(),
object_name(),
pagesize(),
patindex(),
pi(),
pointer_size(),
power(),
proc_role(),
ptn_data_pgs(),
radians(),
rand(),
replicate(),
reserved_pages(),
reserved_pgs(),
reverse(),
right(),
rm_appcontext(),
role_contain(),
role_id(),
role_name(),
round(),
rowcnt(),
row_count(),
rtrim(),
Security Functions,
set_appcontext(),
showplan_in_xml(),
show_role(),
show_sec_services(),
sign(),
sin(),
sortkey(),
soundex(),
space(),
sqrt(),
str(),
String Functions,
stuff(),
style numbers,
substring(),
sum(),
suser_id(),
suser_name(),
syb_sendmsg(),
syb_sendmsg(),
System Functions,
tan(),
tempdb_id(),
to_unichar(),
tran_dumpable_status(),
tsequal(),
uhighsurr(),
ulowsurr(),
upper(),
uscalar(),
used_pages(),
used_pgs(),
user,
user_id(),
user_name(),
valid_name(),
valid_user(),
XML Functions,
year().