유용한 쿼리문 MSSQL - 3

(1) 특정 저장프로시저에서 사용하는 테이블 목록 DECLARE @v_SPName NVARCHAR(50) SET @v_SPName = 'usp_web_UserProcess' ;WITH stored_procedures AS ( SELECT oo.name AS TABLE_NAME, ROW_NUMBER() OVER(PARTITION BY o.name, oo.name ORDER BY o.name, oo.name) AS row FROM sysdepends AS d INNER JOIN sysobjects AS o ON o.id = d.id INNER JOIN sysobjects AS oo ON oo.id = d.depid WHERE o.xtype = 'P' AND o.name LIKE '%' + @v_SPName ..

원문링크 : 유용한 쿼리문 MSSQL - 3