INSERT INTO show_judge (
	id,
	judge_name,
	judge_picture,
	introduce,
	judge_title,
	citizenship,
	judge_sex,
	judge_title_short,
	create_by,
	create_date,
	update_by,
	update_date,
	remarks,
	del_flag
) SELECT
	id,
	cku_title,
	cku_picture,
	cku_content,
	cku_position,
	cku_country,
	cku_sex,
	cab_jobtitle_short,
	1 create_by,
	SYSDATE() create_date,
	1 update_by,
	SYSDATE() update_date,
	'' remarks,
	0 del_flag
FROM
	dbo.cku_caipan;

update show_judge set judge_sex = 1 where judge_sex = '男';
update show_judge set judge_sex = 2 where judge_sex = '女';