I'm small, so share nothing...

當使用 Bulk Insert 時，常會先判斷此檔案是否存在，判斷語法如下：

Set NOCOUNT ON create table #dir (output varchar(2000)) insert into #dir exec master.dbo.xp_cmdshell 'dir E:\POLL41.fmt' if exists (Select * from #dir where output like '%E:\POLL41.fmt%') begin Print 'File found' --Add code you want to run if file exists end else begin Print 'No File Found' --Add code you want to run if file does not exists end drop table #dir

或是可使用

master..xp_fileexist

Usage: EXECUTE xp_fileexist <filename> [, <file_exists INT> OUTPUT]