/*
字符串函数
*/
/*
CHARINDEX函数,下标从1开始,如果没找
到的话返回0,而在java中下标从0开始,没找到的话返回-1
*/
SELECT CHARINDEX('on', 'my name is jiongjiong', 15)
--LEN函数
SELECT LEN('jack')
--LEN函数是求长度
SELECT stuName, stuAddress, LEN(stuAddress) AS '长度' FROM student
--RTRIM函数和LTRIM函数是去掉左右两边的空格
SELECT * FROM student WHERE RTRIM(LTRIM(stuAddress)) = '江西省赣州市'
SELECT * FROM student WHERE LTRIM(stuAddress) = '江西省赣州市'
UPDATE student SET stuAddress = ' 江西省 赣州市 ' WHERE stuId =19
SELECT * FROM student WHERE REPLACE(RTRIM(LTRIM(stuAddress)),' ','') = '江西省赣州市'
SELECT RIGHT('你好,世界', 3)
SELECT LEFT('你好,世界', 3)
SELECT REPLACE('如果你想哭的时候就倒立吧', '哭的', 'cry')
/*
日期函数
*/
SELECT GETDATE()
SELECT DATEADD(DD,10000,'1989-08-27')
/*
DATEADD()比较有用,比如求一个商品的保质期,从今天开
始计算,保质期是68天,那么用该函数就很有用了
*/
SELECT DATEADD(DD,100, GETDATE())
SELECT DATENAME(DW, GETDATE())
SELECT DATENAME(WK, GETDATE())
SELECT DATEPART(DAY,GETDATE())
--
SELECT CURRENT_USER
SELECT SYSTEM_USER
SELECT HOST_NAME()
--
--SELECT stuAge + stuName FROM student --这样会出错
--使用CONVERT()函数,做类型转换
SELECT CONVERT(VARCHAR(4),stuAge) + stuName FROM student
SELECT * FROM student
ORDER BY stuId ASC,
stuAge ASC
SELECT * FROM student
ORDER BY stuId,stuAge ASC
SELECT * FROM student
ORDER BY
stuAge asc,
stuId DESC