当执行SQL脚本时遇到路径过长的问题，可以通过设置环境变量SQLPATH来解决。文章详细解释了如何使用此方法，并通过示例展示了SQLPATH在搜索脚本时的顺序。
when we excute sql script, the absolute path is too long, so what can do ?
you can set Environment Variables "SQLPATH"
example:
SQLPATH=c:\test\test;C:\test\test2
if you use absolute path, this Environment Variables not effective, if you just type
@script.sql , first script.sql will be search in current dir, then will find in SQLPATH by order from left to right.here first search c:\test\test, then search C:\test\test2
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
