Angular – Test error – No base href set

0 Comments

When running a ng test with Angular v6.2.9 cli, I was getting the error: Error: No base href set. Please provide a value for the APP_BASE_HREF token or add a base element to the document.

Select views that don’t reference other views in SQL Server

0 Comments

    — Select views that don’t reference other views. select         s.[name] ,       v.[name] from    sys.views v join    sys.schemas s on v.schema_id = s.schema_id where   v.object_id not in (     select distinct                 r.referenced_id     from        sys.dm_sql_referenced_entities (s.[name] + ‘.’ + v.[name], ‘OBJECT’)

Select views that reference other views in SQL Server

0 Comments

  — Select views that reference other views. select distinct             s.[name] ,           v.[name] ,           r.referenced_schema_name ,           r.referenced_entity_name from        sys.views v join        sys.schemas s on v.schema_id = s.schema_id cross apply sys.dm_sql_referenced_entities (s.[name] + ‘.’ + v.[name], ‘OBJECT’) r join        sys.objects o on