1 CONVERT()
2 SUBSTRING()
3 CHARINDEX()
4CAST()
5 REPLACE()
6 serverproperty()
7 quotename()
sql 查询出来的结果中含有单引号
8 has_dbaccess()
是否可访问指定数据库 HAS_DBACCESS 如果可以访问该数据库,那么 HAS_DBACCESS 返回
9 DATEADD()
10 DATEPART()
11 IS_SRVROLEMEMBER()
12 COLLATIONPROPERTY()
13 LTRIM()
函数从字符串左侧删除空格或其他预定义字符
14 SCHEMA_NAME()
select * from sys.dm_exec_query_stats
select *from sys.dm_exec_sql_text(0x0300FF7FCE167A0AEBF4D700489E000001000000000001111)
select * from events
select quotename(adminName,char(39)) from dbo.bms_admin
select SCHEMA_NAME(adminId) from dbo.bms_admin
select COLLATIONPROPERTY(adminName ,adminId) as ID from bms_admin
-----
select *from sys.types
select * from sys.sp.helplogins
--角色 用户权限
select *from sys.database_principals
--
select * from sys.objects
--系统数据库
select * from sys.databases
select * from sys.tables
select *from sys.plan_guides
select * from sys.fn_helpcollations()
select* from sys.assembly_types
select * from sys.assemblies
select* from sys.fulltext_catalogs
select* from sys.synonyms