请问怎样书写SQL脚本,以判断某个路径下的某个文件是否存在?

比如,我给定路径c:\db.abc。那怎样该文件是否存在?
---------------------------------------------------------------

declare @i int
exec @i=master.dbo.xp_cmdshell 'dir c:\db.abc',NO_OUTPUT
if @i=0 print 'exists'
else print 'non exists'
---------------------------------------------------------------

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus