|
|
|
|
| This example uses the standard DIR command & the documented xp_cmdshell SP. The undocumented sp 'xp_fileexist' is also shown for completeness. |
 Click here to copy the following block | create table #files ( FileName varchar( 255 ) NULL )
declare @cmdstr varchar( 255 ) , @exists bit
select @cmdstr = 'dir/b ' + 'C:\winnt\explorer.exe1' , @exists = 0
insert into #files exec master..xp_cmdshell @cmdstr
if exists( select * from #files )
select @exists = 1
select @exists as FileExists
drop table #files
go
declare @exists int
exec master..xp_fileexist 'c:\winnt\explorer.exe1' , @exists out
select @exists as FileExists |
|
|
|
|
|
|
Submitted By :
Nayan Patel
(Member Since : 5/26/2004 12:23:06 PM)
|
 |
|
|
Job Description :
He is the moderator of this site and currently working as an independent consultant. He works with VB.net/ASP.net, SQL Server and other MS technologies. He is MCSD.net, MCDBA and MCSE. In his free time he likes to watch funny movies and doing oil painting. |
|
View all (893) submissions by this author
(Birth Date : 7/14/1981 ) |
|
|