【Vegas原创】去掉数据库中左右空格SQL语句
update employee set emp_no=rtrim(ltrim(emp_no))
update employee set emp_name=rtrim(ltrim(emp_name))
update employee set login_name=rtrim(ltrim(login_name))
update employee set pass_word=rtrim(ltrim(pass_word))
update employee set dept_code=rtrim(ltrim(dept_code))
update employee set job_desc=rtrim(ltrim(job_desc))
update employee set display_name=rtrim(ltrim(display_name))
update employee set emp_name=rtrim(ltrim(emp_name))
update employee set login_name=rtrim(ltrim(login_name))
update employee set pass_word=rtrim(ltrim(pass_word))
update employee set dept_code=rtrim(ltrim(dept_code))
update employee set job_desc=rtrim(ltrim(job_desc))
update employee set display_name=rtrim(ltrim(display_name))
喜欢请赞赏一下啦^_^