select brno,employee_no,employee_name,english_name,sex,nation,native_place,birthday,employee_state,dept_no,station_no,duty,title,worktype,profession,degree,school,graduate_date,work_date,join_date,regular_date,dimission_date,politics,contract_type,health_state,work_property,join_party_date,retire_type,blood_type,favor,photo_location,dwelling_place,tel,bp,mobile,e_mail,id_card_no,register_place,insurance_no,emcard_no,driver_no,marriage_state,record_no,record_place,sight,heavy,height,contactman,contacttel,resume,salary_level,salary_date,base_salary,allowance,bonus,other_income,retire_salary_part,putout_type,bankcardid,sch,mojar from #SDB..t_bd_employee