Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.
What I'm trying to do is to see if a file exist in a certain directory, the things that I have encounter if the directory has a space the statement doesn't return a true value.
declare @i as integer exec @i = master..xp_cmdshell 'dir \"E:\Adept Technologies\Documents\Building\B07-100001\B07-100001_Expired*.doc\" /b' if @i <> null begin print 'File does exist' end else begin print 'file does not exist' end
|Do aggregate functions work differently when assigned to a variable?||15||33|
|Serach for record in Microsoft SQL Management Studio||8||21|
|Diagnosing if a MSSQL statement is doing something in MSSQL 2008R2||8||16|
|SQL2014 execution plan differences||10||16|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
23 Experts available now in Live!