remove all the options in the dropdown select box.

Use this JavaScript to remove all the options in the dropdown select box.

document.getElementById('Dropdown').length = 0;

update a table from other table sql server

update Employee set email = lgfl.xx_email
from DB2.dbo.directEmployee lgfl join Employee on Employee.emp_name = lgfl.emp_name
where Employee.emp_id = dept.emp_id