| Ctrl+3 | SELECT TOP 9 * FROM |
| Ctrl+4 | EXEC sp_help |
| Ctrl+5 | SELECT * FROM |
| Ctrl+6 | EXEC sp_helptext |
| Ctrl+7 | EXEC ut_VisDipendenze_sq |
| Ctrl+8 | SELECT TOP 20 * FROM sys.objects X ORDER BY X.modify_date DESC |
| Ctrl+0 | SELECT FORMAT(COUNT(*), 'N0') AS [Conta Record] FROM |
CREATE PROCEDURE ut_VisDipendenze_sq
(
@objectName AS nvarchar(1000)
)
AS
BEGIN
--##2019-09-17 - Boso - OBJECT_DEFINITION
SET NOCOUNT ON
IF CHARINDEX('.', @objectName) = 0
SET @objectName = 'dbo.' + @objectName
DECLARE @objectId int = OBJECT_ID(@objectName)
SELECT OBJECT_NAME(referencing_id) AS referencing_entity_name,
o.type_desc AS referencing_desciption,
COALESCE(COL_NAME(referencing_id, referencing_minor_id), '(n/a)') AS referencing_minor_id,
referencing_class_desc,
referenced_server_name, referenced_database_name, referenced_schema_name,
referenced_entity_name
, OBJECT_DEFINITION(OBJECT_ID(referenced_entity_name)) AS referenced_Definition
, COALESCE(COL_NAME(referenced_id, referenced_minor_id), '(n/a)') AS referenced_column_name,
is_caller_dependent, is_ambiguous
FROM sys.sql_expression_dependencies AS sed
INNER JOIN sys.objects AS o ON sed.referencing_id = o.object_id
WHERE referencing_id = @objectId
ORDER BY referencing_entity_name, referencing_desciption
SELECT OBJECT_SCHEMA_NAME ( referencing_id ) AS referencing_schema_name,
OBJECT_NAME(referencing_id) AS referencing_entity_name,
o.type_desc AS referencing_desciption
, OBJECT_DEFINITION(o.object_id) AS referencing_Definition
, COALESCE(COL_NAME(referencing_id, referencing_minor_id), '(n/a)') AS referencing_minor_id,
referencing_class_desc, referenced_class_desc,
referenced_server_name, referenced_database_name, referenced_schema_name,
referenced_entity_name,
COALESCE(COL_NAME(referenced_id, referenced_minor_id), '(n/a)') AS referenced_column_name,
is_caller_dependent, is_ambiguous
FROM sys.sql_expression_dependencies AS sed
INNER JOIN sys.objects AS o
ON sed.referencing_id = o.object_id
WHERE referenced_id = @objectId
ORDER BY referencing_entity_name, referencing_desciption
-- HACK: Returning cross-database dependencies
-- https://msdn.microsoft.com/en-us/library/bb677315.aspx?f=255&MSPPError=-2147217396
END
GO
