比如,我给定路径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'
---------------------------------------------------------------