MSSQL의 유용한 쿼리문

-- 1. DB 정보 EXEC sp_helpdb -- 2.

SP, Trigger, View Text View EXEC sp_helptext 'SP Name' --'SP Name' -- 3. 모든 SP List SELECT DISTINCT o.name, o.xtype FROM syscomments c INNER JOIN sysobjects o ON c.id=o.id WHERE o.xtype='P' -- 4.

특정 테이블이 들어가는 모든 SP List SELECT DISTINCT o.name, o.xtype FROM syscomments c INNER JOIN sysobjects o ON c.id=o.id WHERE c.TEXT LIKE '%Table Name%' AND o.xtype='P' -- 'Tabl.....