문자열

concat

cast, convert

isnull, coalsesce

lower, upper

ltrim, rtrim, trim

len

charindex

left, right

replace

replicate

space

reverse

stuff

str

날짜

getdate, sysdatetime

getutcdate, sysutedatetime

dateadd

datediff

day, month, year

convert

집계

count, count_big

sum

avg

min, max

rollup, cube

stdev, stdevp

수학

abs

sign

celing, floor

round

log

순위함수

row_number

rank

dense_rank

ntile