NuRoN Consulting, INC.

Blog > SQL Tools > Databases > Util > Functions > dbo.ParseSPDefaults

Dependencies for Assembly (CLR) table-valued function: Util.dbo.ParseSPDefaults

ReferencingFQN	ReferencingType	ReferencedFQN	ReferencedType	Depth	RedHierarchy
Util.dbo.ParseSPDefaults	Assembly (CLR) table-valued function	Util.UtilClr	ASSEMBLY	1	[Util].[UtilClr]

Assembly (CLR) table-valued function: Util.dbo.ParseSPDefaults

CREATE FUNCTION [dbo].[ParseSPDefaults]
(@InitialQuotedIdentifiers BIT, @SQL NVARCHAR(MAX))
RETURNS TABLE (
    [ParameterId] SMALLINT NULL,
    [ParameterName] SYSNAME NULL,
    [HasDefault] BIT NULL,
    [Value] NVARCHAR(MAX) NULL,
    [ParsedValue] NVARCHAR(MAX) NULL
)
WITH EXECUTE AS CALLER
AS
EXTERNAL NAME [UtilClr].[UtilClr.ParseSPDefaultsClass].[ParseSPDefaults]

Description for Assembly (CLR) table-valued function: Util.dbo.ParseSPDefaults

Todo