字符串函數(shù):

lower(列名):轉(zhuǎn)為小寫(xiě)

upper(列名):轉(zhuǎn)為大寫(xiě)

charindex('要查的字符','列名'):返回字符所在的位置

len(列名):查詢指定列名的內(nèi)容長(zhǎng)度

select len(name) from singer

replace(列名,舊內(nèi)容,新內(nèi)容):替換內(nèi)容

select sing_name,replace(sing_name,1,'') from singer

subString(列名,開(kāi)始位置,長(zhǎng)度):截取內(nèi)容

select sing_name,SUBSTRING(sing_name,2,2) from singer

reverse(列名):內(nèi)容翻轉(zhuǎn)

select reverse(name)from singer

數(shù)學(xué)函數(shù)

ceiling():向上取整

floor():向下取整

round():四舍五入

power():冪值

abs():絕對(duì)值

sqrt():平方根

時(shí)間函數(shù):

year():取年

month():取月

day():取日

dateadd(MM,1,列名):增加時(shí)間

lower(列名):轉(zhuǎn)為小寫(xiě) upper(列名):轉(zhuǎn)為大寫(xiě)

select sing_imgpath as '原內(nèi)容', lower(sing_imgpath) as '轉(zhuǎn)換小寫(xiě)后', upper(sing_imgpath) as '轉(zhuǎn)換為大寫(xiě)后'from singer?

--去除空格函數(shù)select sing_name,LTRIM(sing_name) as '去除左邊空格' from singerselect sing_name,len(sing_name) as '長(zhǎng)度' from singer

--查詢用戶名長(zhǎng)度為4的用戶select sing_name,len(sing_name) as '長(zhǎng)度',

REVERSE(sing_name) as '翻轉(zhuǎn)后' from singer where len(sing_name)=4?

--返回指定字符的開(kāi)始位置select sing_name,CHARINDEX('周',sing_name) from singer

--截取字符串select sing_name,replace(sing_name,1,'') from singer?

--字符串截取select sing_name,SUBSTRING(sing_name,2,2) from singer

--刪除并插入select sing_name,stuff(sing_name,1,5,'你好') from singer?

--數(shù)學(xué)函數(shù)select sing_cunkuan,CEILING(sing_cunkuan) as '向上取整' from singer

select sing_cunkuan,floor(sing_cunkuan) as '向下取整' from singer?

select sing_cunkuan,round(sing_cunkuan,1) as '四舍五入' from singer?

--冪值select sing_ID,POWER(sing_ID,3) from singer?

--絕對(duì)值select sing_cunkuan,ABS(sing_cunkuan) from singer

--平方根select sing_ID,sqrt(sing_ID) from singer select * from singer

--取年，取月，取日select sing_birthday,YEAR(sing_birthday) '取年',MONTH(sing_birthday) '取月',day(sing_birthday),dateadd(YY,1,sing_birthday) as '增加一個(gè)月' ?from singer??

?select *,'中國(guó)' as '國(guó)家' from singer where singname like '[a-i]'