XinXiangXLX_API/文档/Sql/sql_20190604...

SELECT F_DeptId,F_DeptName,F_DeptCode
  FROM [CallCenter_XinXiangXLX].[dbo].[T_Sys_Department]
--update T_Sys_Department set F_DeptCode=F_ParentCode+convert(varchar,ISNULL(f_deptid,''))+'|'
  
  --Èý¼¶
  --select * from AA_dept3 
--  delete from  AA_dept3  where ISNULL(f_parentid,'')=''
  --insert into T_Sys_Department(F_DeptName,F_ParentCode,F_ParentID,F_State)
  --select F_DeptName,F_ParentCode,F_ParentID,1 from AA_dept3

  --¶þ¼¶
  --select * from AA_dept2 
  --insert into T_Sys_Department(F_DeptName,F_ParentCode,F_ParentID,F_State)
  --select F_DeptName,F_ParentCode,F_ParentID,1 from AA_dept2
  
  --Ò»¼¶
  --select * from AA_dept1
--insert into T_Sys_Department(F_DeptName,F_ParentCode,F_ParentID,F_State)
--  select F_DeptName,F_ParentCode,F_ParentID,F_State from AA_dept1