DB 관련

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..

Install 1. Registry 등록 (HKLM\Software\Firebird Project\Firebird Server\Instances) C:\Firebird\bin>instreg.exe install Firebird has been successfully installed in the registry. 2. NT 서비스 등록 C:\Firebird\bin>instsvc.exe install Service "Firebird Server - DefaultInstance" successfully created. ※ CS(Classic Server) 인 경우 C:\Firebird\bin>instsvc.exe install -classic Service "Firebird Server - De..