functions start from here…

ABS and SubString
  • SELECT abs(-98)
    • Shows positive value, Result =  98
  • SELECT SUBSTRING(‘Usman Mughal’,1,7) ‘Name’
    • Shows String Index 1 to 7 Result = ‘Usman M’

 

Multiple Data Shows in one Column
  • SELECT Convert(char(1), 1) + “-” +Convert(char(2),01) + “-” +Convert(char(2),01) + “-” +
    Convert(char(5),22222) + “-” +Convert(char(3),333) + “-” +Convert(char(6),666666) ‘OneString’

     

    • Shows Combine value, Result =  1-01-01-22222-333-666666

SQL Functions..

 SQL Functions

escape_name map_string

abs abs(%1)
acos acos(%1)
asin asin(%1)
atan atan(%1)
atan2 atn2(%1, %2)
ceiling ceiling(%1)
cos cos(%1)
cot cot(%1)
degrees degrees(%1)
exp exp(%1)
floor floor(%1)
log log(%1)
log10 log10(%1)
pi pi()
power power(%1, %2)
radians radians(%1)
rand rand(%1)
round round(%1, %2)
sign sign(%1)
sin sin(%1)
sqrt sqrt(%1)
tan tan(%1)
ascii ascii(%1)
char char(%1)
concat %1 + %2
difference difference(%1, %2)
insert stuff(%1, %2, %3, %4)
length char_length(%1)
lcase lower(%1)
ltrim ltrim(%1)
repeat replicate(%1, %2)
right right(%1, %2)
rtrim rtrim(%1)
soundex soundex(%1)
space space(%1)
substring substring(%1, %2, %3)
ucase upper(%1)
curdate getdate()
curtime getdate()
dayname datename(dw, %1)
dayofmonth datepart(dd, %1)
dayofweek datepart(dw, %1)
dayofyear datepart(dy, %1)
hour datepart(hh, %1)
minute datepart(mi, %1)
month datepart(mm, %1)
monthname datename(mm, %1)
now getdate()
quarter datepart(qq, %1)
second datepart(ss, %1)
timestampaddsql_tsi_second dateadd(ss, %2, %3)
timestampaddsql_tsi_minute dateadd(mi, %2, %3)
timestampaddsql_tsi_hour dateadd(hh, %2, %3)
timestampaddsql_tsi_day dateadd(dd, %2, %3)
timestampaddsql_tsi_week dateadd(wk, %2, %3)
timestampaddsql_tsi_month dateadd(mm, %2, %3)
timestampaddsql_tsi_quarter dateadd(qq, %2, %3)
timestampaddsql_tsi_year dateadd(yy, %2, %3)
timestampdiffsql_tsi_second datediff(ss, %2, %3)
timestampdiffsql_tsi_minute datediff(mi, %2, %3)
timestampdiffsql_tsi_hour datediff(hh, %2, %3)
timestampdiffsql_tsi_day datediff(dd, %2, %3)
timestampdiffsql_tsi_week datediff(wk, %2, %3)
timestampdiffsql_tsi_month datediff(mm, %2, %3)
timestampdiffsql_tsi_quarter datediff(qq, %2, %3)
timestampdiffsql_tsi_year datediff(yy, %2, %3)
week datepart(wk, %1)
year datepart(yy, %1)
database db_name()
ifnull isnull(%1, %2)
user user_name()
convertsql_binary convert(varbinary(255), %1)
convertsql_bit convert(bit, %1)
convertsql_char convert(varchar(255), %1)
convertsql_date convert(datetime, %1)
convertsql_decimal convert(decimal(36, 18), %1)
convertsql_double convert(float, %1)
convertsql_float convert(float, %1)
convertsql_integer convert(int, %1)
convertsql_longvarbinary convert(varbinary(255), %1)
convertsql_longvarchar convert(varchar(255), %1)
convertsql_real convert(real, %1)
convertsql_smallint convert(smallint, %1)
convertsql_time convert(datetime, %1)
convertsql_timestamp convert(datetime, %1)
convertsql_tinyint convert(tinyint, %1)
convertsql_varbinary convert(varbinary(255), %1)
convertsql_varchar convert(varchar(255), %1)
locate charindex ((convert (varchar, %1)), (convert (varchar, %2)))
character_length char_length(%1)
char_length char_length(%1)
octet_length octet_length(%1)
current_date current_date()
curtime current_time()
current_time current_time()
current_timestamp getdate()