개발 관련

/****** Object:  StoredProcedure [dbo].[SPP_ResultTailInfo_Tree]    Script Date: 2016-07-01 오전 10:27:21 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO-- =============================================-- Author:  jwcho-- Create date: 2016.06.22-- Modify date: 2016.07.01-- =============================================ALTER PROCEDURE [dbo].[SPP_ResultTailInfo_Tree] @V_PRJ_ID VARCHAR(50)=NULL,  ..

with recursive CTE     --(PATH_, Level, PRJ_ID, ID, HR_ID, NAME) as (   select CAST(NAME AS VARCHAR(3000)) AS PATH_, 1 as Level, PRJ_ID, ID, HR_ID, NAME   from CteTable    where PRJ_ID = 'A1607001'     --and ID = 'C00002'    and NAME = '연습'   union all   select cast((t.PATH_ || '/' || e.NAME) as VARCHAR(3000)) as PATH_,(t.Level + 1) as Level, e.PRJ_ID, e.ID, e.HR_ID, e.NAME   from CteTable e joi..

set statistics profile on;set statistics io on;set statistics time on;출처: https://devdb.tistory.com/26 [DB 관련:티스토리]

DBCC DROPCLEANBUFFERS -- sysadmin 권한이 있어야 함DBCC FREEPROCCACHE -- sysadmin 권한이 있어야 함 출처: https://devdb.tistory.com/27 [DB 관련:티스토리]

프로시져에 넘어가는 파라메터의 길이가 길어서 발생하는 오류이다.해결방법은 프로시져 실행하기 전에 SET QUOTED_IDENTIFIER OFF 를 실행하면 된다. 예제)/****** Object:  StoredProcedure [dbo].[SPP_Data_INSERT]    Script Date: 2016-07-29 오후 6:44:26 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER OFFGO -- =============================================-- Author:  jwcho-- Create date: 2016.07.28-- Modify date: 2016.07.28-- Description: 테이블에 데이터를 추가한다. -- 주의사..

-----------------------------------------------------특정 칼럼명을 가진 테이블을 검색select T.name AS table_name, C.name AS column_namefrom sys.tables AS T inner join sys.columns AS Con T.object_id = C.object_idwhere C.name='RotCnt'​---------------------------------------------------출처: https://devdb.tistory.com/29 [DB 관련:티스토리]