var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Path spaces using xp_cmdshelll
I know this is probably a DOS question but does anyone know how the following would work without taking out the spaces in the folder "Audit Tax Planning\" (works fine in paths without spaces)?
Declare @ren varchar(255)
Declare @path varchar(100)
Set @path = '\\main\WGDATA\Accounting\Audit Tax Planning\' --G:\Accounting\Audit Tax Planning\05BE
IF EXISTS(SELECT id FROM tempdb..sysobjects WHERE id = object_ID('tempdb..#Tax_File'))
DROP TABLE #Tax_File
CREATE TABLE [#Tax_File](
Set @ren = 'dir /B ' + @path + 'test.txt'
Insert into #Tax_File ([File_Name])
EXEC master..xp_cmdshell @ren
If not exists(select [File_Name]
where right([File_Name],4) = '.txt')
RAISERROR ('File does not exist.', 16, 1)
select * from #Tax_File
Yup, the quotes inside work, thank you.