2013/022 SQL Server 컬럼에 대한 Description 확인 쿼리 SELECT [Table Name] = OBJECT_NAME(c.object_id) , [Column Name] = c.name , [Description] = ex.value FROM sys.columns c LEFT OUTER JOIN sys.extended_properties ex ON ex.major_id = c.object_id AND ex.minor_id = c.column_id AND ex.name = 'MS_Description' WHERE OBJECTPROPERTY(c.object_id, 'IsMsShipped') = 0 AND OBJECT_NAME(c.object_id) = '테이블명' ORDER BY OBJECT_NAME(c.object_id) , c.column_id 2013. 2. 27. SQL Server SP 상단 주석 제거 퇴근 할려는데 카톡으로 쿼리로 SP 주석 제거 할 수 있는 방법 물어 보길래 한번 만들어 봤습니다. SELECT REPLACE(ss.definition, SUBSTRING(ss.definition, CHARINDEX('/*', ss.definition) - 2, CHARINDEX('*/', ss.definition) + 4 - CHARINDEX('/*', ss.definition)), '') AS [주석제거SP], ss.definition [기존SP] FROM Admin.sys.objects AS so INNER JOIN Admin.sys.sql_modules AS ss ON so.object_id = ss.object_id WHERE so.schema_id = 1 AND type = 'P' AND ss.. 2013. 2. 8. 이전 1 다음