About SQL Path

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

posted on 2011-11-15 16:52  子虚乌有  阅读(152)  评论(0)    收藏  举报