2013의 게시물 표시

성능 향상을 위한 SQL 작성법

nhn개발자 포럼 http://helloworld.naver.com/helloworld/1155

Find SP with used table name

SELECT distinct so.name FROM syscomments sc INNER JOIN sysobjects so ON sc.id=so.id WHERE sc.TEXT LIKE '%AutoPrintHistory%' SELECT o.name, o.type_desc, p.name, p.type_desc FROM sys.sql_dependencies d INNER JOIN sys.objects o     ON d.object_id = o.object_id INNER JOIN sys.objects p     ON d.referenced_major_id = p.object_id     AND o.name = 'RejectionReason' or SELECT o.name, t.TABLE_NAME, c.text   FROM syscomments c   JOIN sysobjects o     ON c.id = o.id   JOIN INFORMATION_SCHEMA.Tables t     ON  c.text LIKE '%RejectionReason%' or EXEC sp_depends @objname = N'RejectionReason';

MS - SQL 특정날짜 이후 생성된 SP 및 TABLE 조회

MS - SQL 특정날짜 이후 생성된 SP 및 TABLE 조회 SP: SELECT * FROM sys.objects WHERE  (create_date > N'2013-01-01' or modify_date > N'2013-01-01' ) TABLE: SELECT * FROM sys.tables WHERE  (create_date > N'2013-01-01' or modify_date > N'2013-01-01' )