CREATE PROCEDURE GetProducts
@ID INT = NULL,
@Name VARCHAR(10) = NULL
AS
BEGIN
	DECLARE @query NVARCHAR(MAX), @params NVARCHAR(MAX)
	IF 1 = 0 
	BEGIN
		-- add other tables that might be used
		SELECT 1 FROM Products WHERE 1 = 0
	END
	SET @params = '@IdIn INT, @NameIn VARCHAR(10)'
	SET @query = 'SELECT * FROM dbo.Products WHERE 1 = 1'
	IF @ID IS NOT NULL SET @query = @query + ' AND ProductID =  @IdIn'
	IF @Name IS NOT NULL SET @query = @query + ' AND ProductName = @NameIn'
	EXEC sp_executesql @query, @params, @IdIn = @Id, @NameIn = @Name
END

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

SELECT referenced_schema_name, referenced_entity_name, referenced_minor_name, 
    referenced_minor_id, referenced_class_desc
FROM sys.dm_sql_referenced_entities ('dbo.GetProducts2', 'OBJECT')

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

We walk in the dark places no others will enter
We stand on the bridge and no one may pass