<div>
:This is a start -- I need to work out how to get the CRLF characters into the XYZ variable...<br />
<br />
@echo off<br />
setlocal enabledelayedexpansion<br />
for /f &quot;delims=&quot; %%V in ('type C:\path\YourFile.txt') do set XYZ=!XYZ!%%V<br />
echo XYZ=!XYZ!<br />

</div>


<div>
Your start is the same concept I had when I stated in my question I could probably do this inside of a FOR Loop. &nbsp;I'm hoping for something different.
</div>


<div>
However, you can pipe the top line (only) of a text file to a variable:<br />
<br />
set /p MyVar=
</div>


<div>
Ah. Yes /p which prompts and that CAN accept a redirect.<br />
<br />
So, if the file didn't have line breaks ....
</div>


<div>
It was the same as my what i was hoping to better in my original post. &nbsp;I even suggested this as an answer.
</div>


<div>
<div class="content wysiwyg-content">
How can I set a DOS variable, in a W2k3 batch file, to the contents of a text file. &nbsp;File may have over 5000 characters?<br />
<br />
I can get 1st line in from set /p switch, and I figure I can put this into a FOR loop and append each line possibly. &nbsp;But I'm hoping there is a PIPE or redirection or some really slick way to do this.<br />
<br />
My goal is to try to NOT use an SQL stored procedure that has this query and to instead use the SQL string from the text file to input as my QUERYOUT string.<br />

</div>
</div>


How can I set a DOS variable, in a W2k3 batch file, to the contents of a text file.  File may have over 5000 characters?

I can get 1st line in from set /p switch, and I figure I can put this into a FOR loop and append each line possibly.  But I'm hoping there is a PIPE or redirection or some really slick way to do this.

My goal is to try to NOT use an SQL stored procedure that has this query and to instead use the SQL string from the text file to input as my QUERYOUT string.


Setting DOS variable to contents of text file

Batch files are text files containing a script of commands that are executed by the command interpreter on DOS, OS/2 and Windows systems. Most commonly, they are used to perform a series of functions that are repeated -- copying a set of files created daily with one step, for example.

Windows Batch

Microsoft Disk Operating System (MS-DOS) was an operating system for x86-based personal computers, and traces of it are still found in the Windows operating system. DOS is still used in some embedded systems and for certain legacy 16-bit networks.