搜尋
首頁資料庫mysql教程所有行业分类sql，带查找索引

所有行业分类sql，带查找索引

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Jun 07, 2016 pm 05:43 PM
分類尋找索引產業

CREATE TABLE [NT_Ex_Resumes_Jobs]( [JobId] [int] IDENTITY(1,1) NOT NULL, [JobName] [nvarchar](500) NULL, [ParentId] [int] NULL, [JobIndex] [nvarchar](max) NULL, CONSTRAINT [PK_NT_Ex_Resumes_Jobs] PRIMARY KEY CLUSTERED ( [JobId] ASC )WITH (

CREATE TABLE [NT_Ex_Resumes_Jobs](
[JobId] [int] IDENTITY(1,1) NOT NULL,
[JobName] [nvarchar](500) NULL,
[ParentId] [int] NULL,
[JobIndex] [nvarchar](max) NULL,
CONSTRAINT [PK_NT_Ex_Resumes_Jobs] PRIMARY KEY CLUSTERED
(
[JobId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
go
declare @JobIndex nvarchar(max),@ParentJobId int,@PParentJobId int,@TempPid int
set @JobIndex = (select MAX(JobId) from NT_Ex_Resumes_Jobs)
if @JobIndex is null
set @JobIndex = 1
else
set @JobIndex = @JobIndex + 1
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('计算机/互联网/通信/电子',0,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='计算机/互联网/通信/电子')
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex = CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('计算机硬件',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='计算机硬件')
set @TempPid = (select ParentId from NT_Ex_Resumes_Jobs where JobName='计算机硬件')
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('高级硬件工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('硬件工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('其他1',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='计算机/互联网/通信/电子')
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex = CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('计算机软件',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='计算机软件')
set @TempPid = (select ParentId from NT_Ex_Resumes_Jobs where JobName='计算机软件')
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('高级软件工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('软件工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('软件UI设计师/工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('仿真应用工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('ERP实施顾问',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('ERP技术开发',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('需求工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('系统集成工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('系统分析员',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('系统工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('系统架构设计师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('数据库工程师/管理员',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('计算机辅助设计工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('其他2',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='计算机/互联网/通信/电子')
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex = CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('互联网/电子商务/网游',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='互联网/电子商务/网游')
set @TempPid = (select ParentId from NT_Ex_Resumes_Jobs where JobName='互联网/电子商务/网游')
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('互联网软件开发工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('多媒体/游戏开发工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('网站营运经理/主管',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('网络工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('系统管理员/网络管理员',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('网站策划',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('网站编辑',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('网页设计/制作/美工',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('网络信息安全工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('智能大厦/综合布线',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('其他3',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('网站架构设计师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('网站维护工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('语音/视频开发工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('UI设计师/顾问',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('网站营运专员',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('脚本开发工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('游戏策划师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('游戏界面设计师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('Flash设计/开发',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('特效设计师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('视觉设计师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('音效设计师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('SEO搜索引擎优化',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('产品经理/主管',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('产品专员',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('电子商务经理/主管',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('电子商务专员',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('网店店长/客服',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='计算机/互联网/通信/电子')
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex = CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('IT-管理',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='IT-管理')
set @TempPid = (select ParentId from NT_Ex_Resumes_Jobs where JobName='IT-管理')
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('首席技术执行官CTO/首席信息官CIO',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('技术总监/经理',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('信息技术经理/主管',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('信息技术专员',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('项目总监',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('项目经理',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('项目主管',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('项目执行/协调人员',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('其他4',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='计算机/互联网/通信/电子')
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex = CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('IT-品管、技术支持及其它',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='IT-品管、技术支持及其它')
set @TempPid = (select ParentId from NT_Ex_Resumes_Jobs where JobName='IT-品管、技术支持及其它')
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('技术支持/维护经理',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('技术支持/维护工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('计量工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('标准化工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('品质经理',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('系统测试',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('软件测试',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('硬件测试',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('测试员',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('技术文员/助理',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('其他5',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('Helpdesk 技术支持',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('文档工程师',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='计算机/互联网/通信/电子')
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex = CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('通信技术开发及应用',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='通信技术开发及应用')
set @TempPid = (select ParentId from NT_Ex_Resumes_Jobs where JobName='通信技术开发及应用')
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('通信技术工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('有线传输工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('无线通信工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('电信交换工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('数据通信工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('移动通信工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('电信网络工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('通信电源工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('其他6',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('增值产品开发工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('手机软件开发工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('手机应用开发工程师',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='计算机/互联网/通信/电子')
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex = CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('电子/电器/半导体/仪器仪表',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='电子/电器/半导体/仪器仪表')
set @TempPid = (select ParentId from NT_Ex_Resumes_Jobs where JobName='电子/电器/半导体/仪器仪表')
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('集成电路IC设计/应用工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('IC验证工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('电子工程师/技术员',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('电气工程师/技术员',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('电路工程师/技术员(模拟/数字)',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('电声/音响工程师/技术员',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('半导体技术',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('自动控制工程师/技术员',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('电子软件开发(ARM/MCU...)',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('嵌入式软件开发(Linux/单片机/DLC/DSP…)',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('电池/电源开发',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('FAE 现场应用工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('家用电器/数码产品研发',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('仪器/仪表/计量分析师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('测试工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('其他7',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('电子技术研发工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('激光/光电子技术',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('嵌入式硬件开发(主板机…)',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('电子/电器维修工程师/技师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('变压器与磁电工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('版图设计工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('工艺工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('射频工程师',@ParentJobId,@JobIndex)
set @JobIndex = (select MAX(JobId) from NT_Ex_Resumes_Jobs)
if @JobIndex is null
set @JobIndex = 1
else
set @JobIndex = @JobIndex + 1
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('销售/客服/技术支持',0,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='销售/客服/技术支持')
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex = CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('销售管理',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='销售管理')
set @TempPid = (select ParentId from NT_Ex_Resumes_Jobs where JobName='销售管理')
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('销售总监',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('销售经理',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('销售主管',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('业务拓展主管/经理',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('渠道/分销总监',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('渠道/分销经理',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('渠道/分销主管',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('大客户经理',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('客户经理/主管',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('区域销售总监',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('区域销售经理',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('团购经理/主管',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('其他8',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='销售/客服/技术支持')
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex = CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('销售人员',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='销售人员')
set @TempPid = (select ParentId from NT_Ex_Resumes_Jobs where JobName='销售人员')
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('销售代表',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('渠道/分销专员',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('客户代表',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('销售工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('电话销售',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('经销商',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('其他9',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('团购业务员',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='销售/客服/技术支持')
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex = CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('销售行政及商务',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='销售行政及商务')
set @TempPid = (select ParentId from NT_Ex_Resumes_Jobs where JobName='销售行政及商务')
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('销售行政经理/主管',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('销售行政专员/助理',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('商务经理',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('商务主管/专员',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('商务助理',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('销售助理',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('其他10',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('业务分析经理/主管',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('业务分析专员/助理',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='销售/客服/技术支持')
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex = CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('客服及技术支持',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='客服及技术支持')
set @TempPid = (select ParentId from NT_Ex_Resumes_Jobs where JobName='客服及技术支持')
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('客服总监(非技术)',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('客服经理(非技术)',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('客服主管(非技术)',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('客服专员/助理(非技术)',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('售前/售后技术支持经理',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('售前/售后技术支持主管',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('售前/售后技术支持工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('咨询热线/呼叫中心服务人员',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('其他11',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('客户关系经理/主管',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('投诉专员',@ParentJobId,@JobIndex

陳述
本文內容由網友自願投稿，版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容，請聯絡admin@php.cn
相關文章
MySQL中的存儲過程是什麼？MySQL中的存儲過程是什麼？May 01, 2025 am 12:27 AM

存儲過程是MySQL中的預編譯SQL語句集合，用於提高性能和簡化複雜操作。 1.提高性能：首次編譯後，後續調用無需重新編譯。 2.提高安全性：通過權限控制限制數據表訪問。 3.簡化複雜操作：將多條SQL語句組合，簡化應用層邏輯。

查詢緩存如何在MySQL中工作？查詢緩存如何在MySQL中工作？May 01, 2025 am 12:26 AM

MySQL查詢緩存的工作原理是通過存儲SELECT查詢的結果，當相同查詢再次執行時，直接返回緩存結果。 1）查詢緩存提高數據庫讀取性能，通過哈希值查找緩存結果。 2）配置簡單，在MySQL配置文件中設置query_cache_type和query_cache_size。 3）使用SQL_NO_CACHE關鍵字可以禁用特定查詢的緩存。 4）在高頻更新環境中，查詢緩存可能導致性能瓶頸，需通過監控和調整參數優化使用。

與其他關係數據庫相比，使用MySQL的優點是什麼？與其他關係數據庫相比，使用MySQL的優點是什麼？May 01, 2025 am 12:18 AM

MySQL被廣泛應用於各種項目中的原因包括：1.高性能與可擴展性，支持多種存儲引擎；2.易於使用和維護，配置簡單且工具豐富；3.豐富的生態系統，吸引大量社區和第三方工具支持；4.跨平台支持，適用於多種操作系統。

您如何處理MySQL中的數據庫升級？您如何處理MySQL中的數據庫升級？Apr 30, 2025 am 12:28 AM

MySQL數據庫升級的步驟包括：1.備份數據庫，2.停止當前MySQL服務，3.安裝新版本MySQL，4.啟動新版本MySQL服務，5.恢復數據庫。升級過程需注意兼容性問題，並可使用高級工具如PerconaToolkit進行測試和優化。

您可以使用MySQL的不同備份策略是什麼？您可以使用MySQL的不同備份策略是什麼？Apr 30, 2025 am 12:28 AM

MySQL備份策略包括邏輯備份、物理備份、增量備份、基於復制的備份和雲備份。 1.邏輯備份使用mysqldump導出數據庫結構和數據，適合小型數據庫和版本遷移。 2.物理備份通過複製數據文件，速度快且全面，但需數據庫一致性。 3.增量備份利用二進制日誌記錄變化，適用於大型數據庫。 4.基於復制的備份通過從服務器備份，減少對生產系統的影響。 5.雲備份如AmazonRDS提供自動化解決方案，但成本和控制需考慮。選擇策略時應考慮數據庫大小、停機容忍度、恢復時間和恢復點目標。

什麼是mySQL聚類？什麼是mySQL聚類？Apr 30, 2025 am 12:28 AM

MySQLclusteringenhancesdatabaserobustnessandscalabilitybydistributingdataacrossmultiplenodes.ItusestheNDBenginefordatareplicationandfaulttolerance,ensuringhighavailability.Setupinvolvesconfiguringmanagement,data,andSQLnodes,withcarefulmonitoringandpe

如何優化數據庫架構設計以在MySQL中的性能？如何優化數據庫架構設計以在MySQL中的性能？Apr 30, 2025 am 12:27 AM

在MySQL中優化數據庫模式設計可通過以下步驟提升性能：1.索引優化：在常用查詢列上創建索引，平衡查詢和插入更新的開銷。 2.表結構優化：通過規範化或反規範化減少數據冗餘，提高訪問效率。 3.數據類型選擇：使用合適的數據類型，如INT替代VARCHAR，減少存儲空間。 4.分區和分錶：對於大數據量，使用分區和分錶分散數據，提升查詢和維護效率。

您如何優化MySQL性能？您如何優化MySQL性能？Apr 30, 2025 am 12:26 AM

tooptimizemysqlperformance，lofterTheSeSteps：1）inasemproperIndexingTospeedUpqueries，2）使用ExplaintplaintoAnalyzeandoptimizequeryPerformance，3）ActiveServerConfigurationStersLikeTlikeTlikeTlikeIkeLikeIkeIkeLikeIkeLikeIkeLikeIkeLikeNodb_buffer_pool_sizizeandmax_connections，4）

See all articles

熱AI工具

Undresser.AI Undress

Undresser.AI Undress

人工智慧驅動的應用程序，用於創建逼真的裸體照片

AI Clothes Remover

AI Clothes Remover

用於從照片中去除衣服的線上人工智慧工具。

Undress AI Tool

Undress AI Tool

免費脫衣圖片

Clothoff.io

Clothoff.io

AI脫衣器

Video Face Swap

Video Face Swap

使用我們完全免費的人工智慧換臉工具，輕鬆在任何影片中換臉！

顯示更多

熱門文章

Windows 11 KB5054979中的新功能以及如何解決更新問題
4 週前ByDDD
如何修復KB5055523無法在Windows 11中安裝？
3 週前ByDDD
Inzoi：如何申請學校和大學
1 個月前ByDDD
如何修復KB5055518無法在Windows 10中安裝？
3 週前ByDDD
在哪裡可以找到Atomfall中的站點辦公室鑰匙
4 週前ByDDD
顯示更多

熱工具

mPDF

mPDF

mPDF是一個PHP庫，可以從UTF-8編碼的HTML產生PDF檔案。原作者Ian Back編寫mPDF以從他的網站上「即時」輸出PDF文件，並處理不同的語言。與原始腳本如HTML2FPDF相比，它的速度較慢，並且在使用Unicode字體時產生的檔案較大，但支援CSS樣式等，並進行了大量增強。支援幾乎所有語言，包括RTL（阿拉伯語和希伯來語）和CJK（中日韓）。支援嵌套的區塊級元素（如P、DIV），

Safe Exam Browser

Safe Exam Browser

Safe Exam Browser是一個安全的瀏覽器環境，安全地進行線上考試。該軟體將任何電腦變成一個安全的工作站。它控制對任何實用工具的訪問，並防止學生使用未經授權的資源。

MantisBT

MantisBT

Mantis是一個易於部署的基於Web的缺陷追蹤工具，用於幫助產品缺陷追蹤。它需要PHP、MySQL和一個Web伺服器。請查看我們的演示和託管服務。

SAP NetWeaver Server Adapter for Eclipse

SAP NetWeaver Server Adapter for Eclipse

將Eclipse與SAP NetWeaver應用伺服器整合。

VSCode Windows 64位元 下載

VSCode Windows 64位元 下載

微軟推出的免費、功能強大的一款IDE編輯器

顯示更多

熱門話題

gmail信箱登陸入口在哪裡
7899
15
Java教學
1651
14
CakePHP 教程
1411
52
Laravel 教程
1303
25
PHP教程
1248
29
顯示更多