펌) select row 합치기 펌 ) http://jjun7983.tistory.com/211 SELECT DISTINCTSTUFF((SELECT merge_column + '^'FROM table_nameWHERE where_column = '10'FOR XML PATH('')),1,0,'') ASFROM table_namemerge_column : 합쳐야 할 컬럼where_column : 조건 컬럼table_name : 테이블명결과 : column^column^column DB/MS SQL 2016. 6. 29. 14:59
텍스트 자르기 함수(테이블 반환) -- ================================================ -- Template generated from Template Explorer using: -- Create Scalar Function (New Menu).SQL -- -- Use the Specify Values for Template Parameters -- command (Ctrl-Shift-M) to fill in the parameter -- values below. -- -- This block of comments will not be included in -- the definition of the function. -- =========================================.. DB/MS SQL 2014. 3. 19. 09:43
프로시져 및 테이블 검색 입니다. SELECT O.NAME, O.OBJECT_ID, O.TYPE, O.TYPE_DESC FROM SYS.OBJECTS O INNER JOIN SYS.SYSCOMMENTS C ON O.OBJECT_ID = C.ID WHERE 1=1 AND O.TYPE IN ('P', 'FN', 'TF', 'IF') AND C.TEXT LIKE '%테이블명%' ORDER BY O.NAME DB/MS SQL 2013. 11. 29. 16:24
칼럼에 설명 추가 EXEC sp_addextendedproperty@name = N'MS_Description', @value = N'설명',@level0Type = N'Schema', @Level0Name = dbo,@level1Type = N'Table', @Level1Name = '테이블이름',@level2Type = N'Column', @Level2Name = '칼럼명'; DB/MS SQL 2013. 11. 29. 16:19
