所有行业分类sql，带查找索引-mysql チュートリアル-php.cn

ホームページ

データベース

mysql チュートリアル

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

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 (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 までご連絡ください。

InnoDBバッファープールとそのパフォーマンスの重要性を説明してください。Apr 19, 2025 am 12:24 AM

Innodbbufferpoolは、データをキャッシュしてページをインデックス作成することにより、ディスクI/Oを削減し、データベースのパフォーマンスを改善します。その作業原則には次のものが含まれます。1。データ読み取り：Bufferpoolのデータを読む。 2。データの書き込み：データを変更した後、bufferpoolに書き込み、定期的にディスクに更新します。 3.キャッシュ管理：LRUアルゴリズムを使用して、キャッシュページを管理します。 4.読みメカニズム：隣接するデータページを事前にロードします。 BufferPoolのサイジングと複数のインスタンスを使用することにより、データベースのパフォーマンスを最適化できます。

MySQL対その他のプログラミング言語：比較Apr 19, 2025 am 12:22 AM

他のプログラミング言語と比較して、MySQLは主にデータの保存と管理に使用されますが、Python、Java、Cなどの他の言語は論理処理とアプリケーション開発に使用されます。 MySQLは、データ管理のニーズに適した高性能、スケーラビリティ、およびクロスプラットフォームサポートで知られていますが、他の言語は、データ分析、エンタープライズアプリケーション、システムプログラミングなどのそれぞれの分野で利点があります。

MySQLの学習：新しいユーザー向けの段階的なガイドApr 19, 2025 am 12:19 AM

MySQLは、データストレージ、管理、分析に適した強力なオープンソースデータベース管理システムであるため、学習する価値があります。 1）MySQLは、SQLを使用してデータを操作するリレーショナルデータベースであり、構造化されたデータ管理に適しています。 2）SQL言語はMySQLと対話するための鍵であり、CRUD操作をサポートします。 3）MySQLの作業原則には、クライアント/サーバーアーキテクチャ、ストレージエンジン、クエリオプティマイザーが含まれます。 4）基本的な使用には、データベースとテーブルの作成が含まれ、高度な使用にはJoinを使用してテーブルの参加が含まれます。 5）一般的なエラーには、構文エラーと許可の問題が含まれ、デバッグスキルには、構文のチェックと説明コマンドの使用が含まれます。 6）パフォーマンスの最適化には、インデックスの使用、SQLステートメントの最適化、およびデータベースの定期的なメンテナンスが含まれます。

MySQL：初心者が習得するための必須スキルApr 18, 2025 am 12:24 AM

MySQLは、初心者がデータベーススキルを学ぶのに適しています。 1.MySQLサーバーとクライアントツールをインストールします。 2。selectなどの基本的なSQLクエリを理解します。 3。マスターデータ操作：テーブルを作成し、データを挿入、更新、削除します。 4.高度なスキルを学ぶ：サブクエリとウィンドウの関数。 5。デバッグと最適化：構文を確認し、インデックスを使用し、選択*を避け、制限を使用します。

MySQL：構造化データとリレーショナルデータベースApr 18, 2025 am 12:22 AM

MySQLは、テーブル構造とSQLクエリを介して構造化されたデータを効率的に管理し、外部キーを介してテーブル間関係を実装します。 1.テーブルを作成するときにデータ形式と入力を定義します。 2。外部キーを使用して、テーブル間の関係を確立します。 3。インデックス作成とクエリの最適化により、パフォーマンスを改善します。 4.データベースを定期的にバックアップおよび監視して、データのセキュリティとパフォーマンスの最適化を確保します。

MySQL：説明されている主要な機能と機能Apr 18, 2025 am 12:17 AM

MySQLは、Web開発で広く使用されているオープンソースリレーショナルデータベース管理システムです。その重要な機能には、次のものが含まれます。1。さまざまなシナリオに適したInnodbやMyisamなどの複数のストレージエンジンをサポートします。 2。ロードバランスとデータバックアップを容易にするために、マスタースレーブレプリケーション機能を提供します。 3.クエリの最適化とインデックスの使用により、クエリ効率を改善します。

SQLの目的：MySQLデータベースとの対話Apr 18, 2025 am 12:12 AM

SQLは、MySQLデータベースと対話して、データの追加、削除、変更、検査、データベース設計を実現するために使用されます。 1）SQLは、ステートメントの選択、挿入、更新、削除を介してデータ操作を実行します。 2）データベースの設計と管理に作成、変更、ドロップステートメントを使用します。 3）複雑なクエリとデータ分析は、ビジネス上の意思決定効率を改善するためにSQLを通じて実装されます。

初心者向けのMySQL：データベース管理を開始しますApr 18, 2025 am 12:10 AM

MySQLの基本操作には、データベース、テーブルの作成、およびSQLを使用してデータのCRUD操作を実行することが含まれます。 1.データベースの作成：createdatabasemy_first_db; 2。テーブルの作成：createTableBooks（idintauto_incrementprimarykey、titlevarchary（100）notnull、authorvarchar（100）notnull、published_yearint）; 3.データの挿入：InsertIntoBooks（タイトル、著者、公開_year）VA

See all articles

ホットAIツール

Undresser.AI Undress

リアルなヌード写真を作成する AI 搭載アプリ

AI Clothes Remover

写真から衣服を削除するオンライン AI ツール。

Undress AI Tool

脱衣画像を無料で

Clothoff.io

AI衣類リムーバー

AI Hentai Generator

AIヘンタイを無料で生成します。

ホットツール

MinGW - Minimalist GNU for Windows

このプロジェクトは osdn.net/projects/mingw に移行中です。引き続きそこでフォローしていただけます。 MinGW: GNU Compiler Collection (GCC) のネイティブ Windows ポートであり、ネイティブ Windows アプリケーションを構築するための自由に配布可能なインポートライブラリとヘッダーファイルであり、C99 機能をサポートする MSVC ランタイムの拡張機能が含まれています。すべての MinGW ソフトウェアは 64 ビット Windows プラットフォームで実行できます。