sqlserver函数
来源:互联网 发布:淘宝集市店 编辑:程序博客网 时间:2024/05/21 08:50
-
-
-
-
-
-
- select ASCII('AB') as ascii
-
-
-
- select CHAR(65) as char
-
-
-
- select CHARINDEX('a','gdsahhfah')
- select CHARINDEX('a','gdsahhfah',5)
-
-
-
-
-
- select DIFFERENCE('aa','bb')
- select DIFFERENCE('eceeaag','ab')
-
-
-
- select LEFT('sbcaaabc',4)
-
-
-
- select RIGHT('gdacdf',3)
-
-
-
- select LEN(' a bcdef ')
-
-
-
- select LOWER('AAAA')
-
-
-
- select UPPER('aaaa')
-
-
-
- select LTRIM(' abc')
-
-
-
- select RTRIM('abc ')
-
-
-
- select REVERSE('12345')
-
-
-
- select '123'+SPACE('2')+'b'
-
-
-
-
-
- select STR('123.567',10,3)
-
-
-
- select STUFF('abcdef',3,2,'ABC')
-
-
-
- select SUBSTRING('abcdef',2,4)
-
-
-
- select REPLACE('abcdefbc','bc','BC')
-
-
-
- select DATEADD(YEAR,10,'2000-9-9')
-
-
-
- select DATEDIFF(YEAR,'2000-9-9','2010-9-9')
-
-
-
-
- select datename(mm,'2007-12-11')
- select DATENAME(dw,'2016-9-6')
- select DATENAME(WK,'2016-9-6')
- select DATENAME(DY,'2016-9-6')
-
-
-
- select DATEPART(YEAR,'2016-9-6')
-
-
-
- select GETDATE()
-
-
- select getutcdate()
-
-
-
- select RAND()
-
-
-
- select ROUND(1235.4674,1)
-
-
-
- select N'年龄:'+convert(nvarchar,23)
- select convert(nvarchar ,getdate())
-
-
-
- select cast(123 as nvarchar)
-
-
-
- select NEWID() as GUID
-
-
-
- select ISNUMERIC('g')
- select ISNUMERIC('113')
-
-
-
- select ISNULL(null,'234g')
- select ISNULL('gsgd','33333')
-
-
-
- select ISDATE('gggs')
- select ISDATE('2019-5-8')
-
-
-
-
-
-
- select empId,empName,Salary,row_number() over(order by Salary desc) as rank from Tab_Salary
-
-
-
-
- select empId,empName,Salary,rank() over(order by Salary desc) as rank from Tab_Salary
-
-
-
-
-
- select empId,empName,Salary,dense_rank() over(order by Salary desc) as rank from Tab_Salary
-
-
-
-
-
-
-
-
-
-
- select AVG(Salary) from Tab_Salary
-
-
-
- select COUNT(*) from Tab_Salary
- select COUNT(distinct Salary) from Tab_Salary
-
-
-
- select min(Salary) from Tab_Salary
-
-
-
- select max(Salary) from Tab_Salary
-
-
-
- select sum(Salary) from Tab_Salary
参考博客:http://blog.csdn.net/wanlong360599336/article/details/52450146