전체 글234 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. [유럽여행] 스위스 - 알프스의 하이디산 쉔브엘산 자연과 하나되는 아름다운 전원 풍경 ~~~ 하이디산(2208m) 에 올라 저 멀리 보이는 만년설은 1년이 지난 지금도 그 모습에 눈에 아른 거린다. 2013. 1. 12. RECOVERY_PENDING 복구 방법 RECOVERY PENDING The database will be in this state if SQL Server knows that recovery needs to be run on the database but something is preventing recovery from starting. This is different from SUSPECT because there's nothing to say that recovery is going to fail - it just hasn't started yet. An example of this is when the database wasn't cleanly shut down (i.e. there was at least one uncommitted.. 2012. 12. 21. 이전 1 2 3 4 5 6 ··· 59 다음
