블로그 이미지
불쥐의 눈으로 본세상 ㏈ª ☞ β┖υΕJini.κR

카테고리

분류 전체보기 (234)
By β┖υΕJini (131)
㏈ª By β┖υΕJini (103)
Total268,277
Today62
Yesterday69

'2013/02'에 해당되는 글 2건

  1. 2013.02.27 SQL Server 컬럼에 대한 Description 확인 쿼리
  2. 2013.02.08 SQL Server SP 상단 주석 제거

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

 

Posted by ㏈ª ☞ β┖υΕJini.κR

퇴근 할려는데 카톡으로 쿼리로 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.definition LIKE '%/*%'


 

Posted by ㏈ª ☞ β┖υΕJini.κR