【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))
喜欢请赞赏一下啦^_^赞赏后请加wx:weyocul,相关文章提到的的安装包稍后给到哦!没有收到赞赏直接加我的,直接无视哈!

浙公网安备 33010602011771号