SQL Server数据库引擎.NET CLR环境数据库管理员向导（2）

核心提示： 标量函数-- List CLR Scalar FunctionsSELECT schema_name(so.schema_id) + N'.' + so.[name] AS [Name], so.create_date, so.modify_date, sa.permiss

标量函数

-- List CLR Scalar Functions
SELECT schema_name(so.schema_id) + N'.' + so.[name] AS [Name]
, so.create_date, so.modify_date
, sa.permission_set_desc AS [Access]
FROM sys.objects AS so
INNER JOIN sys.module_assembly_usages AS sau
ON so.object_id = sau.object_id
INNER JOIN sys.assemblies AS sa
ON sau.assembly_id = sa.assembly_id
WHERE so.type_desc = N'CLR_SCALAR_FUNCTION'

表值函数

-- List CLR Table Functions
SELECT schema_name(so.schema_id) + N'.' + so.[name] AS [Name]
, so.create_date, so.modify_date
, sa.permission_set_desc AS [Access]
FROM sys.objects AS so
INNER JOIN sys.module_assembly_usages AS sau
ON so.object_id = sau.object_id
INNER JOIN sys.assemblies AS sa
ON sau.assembly_id = sa.assembly_id
WHERE so.type_desc = N'CLR_TABLE_VALUED_FUNCTION'

用户定义聚合

-- List CLR Aggregate Functions
SELECT schema_name(so.schema_id) + N'.' + so.[name] AS [Name]
, so.create_date
, so.modify_date
, sa.permission_set_desc AS [Access]
FROM sys.objects AS so
INNER JOIN sys.module_assembly_usages AS mau
ON so.object_id = mau.object_id
INNER JOIN sys.assemblies AS sa
ON mau.assembly_id = sa.assembly_id
WHERE so.type_desc = N'AGGREGATE_FUNCTION'

用户定义类型