Dos batch file operations

The batch script will then run the OSQL. In fact the file can be opened and executed in Query Analyzer as is, since the batch script in the file looks like a comment to the query language processor. Now we can embed SQL queries into a batch file. But how can we pass arguments from the batch script into SQL? This can be done using a temporary table. Temporary tables live as long as the connection to the SQL Server. EXE twice? The trick is that OSQL allows to use the -i and -q option at the same time whereas: -q specifies a query string to be executed -i specifies a filename with SQL syntax to be executed Both the query string and the SQL file will be executed using the same Server connection.

Some testing shows that the query string -q will always be executed before the -I SQL file, which allows us to use a query string to set up a temporary table. The trick of renaming the Perl. However the solution I have seen so far needed batch code before and after the Perl script where as the solution presented below only needs some lines of DOS at the top.

The added DOS script is generic and works independent from the name of the file. When running the batch the DOS command interpreter will read the first lines and execute the file itself in Perl context. This example works just as the previews one but will wait 4 seconds before the application finally closes. This is just enough time to inspect the screen output before the window vanishes. The delay can probably be done much easier in Perl, but somebody just starting on Perl might find this still useful.

TOP Simple menu framework. Plug in a new menu item and coresponding script as single function block. Example: FTP -v -i -s:ftpscript. Script Output. Example - Installation Framework. Features: simple and well structured settings changeable at runtime settings are persistent , the batch will remember all settings from the last run progress indication during simulated file installation.

Download: BatchInstall. Simulating an installation for! Pretend to install! This advanced batch template features: Initialization of the command processor Version History for manual script change tracking Window title of choice Delayed exit for unattended completion.

Download: BatchDelayOnExit. Hello World REM. Features: The lookup list will be appended to the batch file itself. Download: BatchListOfFiles. FileSearch, type '-' to refresh lookup list: logoMed.

Download: BatchSubstitute. Showing progress in the output window seems impractical in DOS batch, since there is no way to overwrite a previews output for an updated progress status during each progress tick. Using the ECHO command is not nice, screen content quickly scrolls out of sight. A nice side effect is that you can minimize the batch window and still observe the progress output in the task bar, since the task bar text will always reflect the window title text. Download: DosProgress.

A Quine is a program whose only output is its program code. This little Quine has been developed by Peter Hartmann. If you use this code make sure to add a reference to DosTips.

Features: simple and well structured easy to enhance easy to maintain. Download: BatchMenu. The function template can be used as starting point for a new function. Complete the template into a useful function like this: Rename the function Add proper description for the function and its arguments Fill in the function body Return desired values. Download: BatchFunctionTmpl.

Date and Time functions are useful for: Calculations with date and time values Determine the age of files in days Determine the date difference in days The example in this section demonstrates how to use the :ftime function to determine the age in days of all files in the temp directory. Download: BatchFTime. Download: FtpLogin. This batch connects twice to the FTP server. This batch executed the FTP script embedded within the batch. Embed FTP script into a batch script.

Features: Single file to distribute combining batch and FTP script. Local files that are are not in this list will then be uploaded during a second connection. If you have multiple FTP scripts that all use the same login information to your FTP site then you may wish to manage the login information separately from your FTP scripts in a single place.

Download: FtpLoginSharing. Embedding SQL script within a batch script is just as easy. Download: Batch4SQL. Download: Batch4SQL2. The following examples show how to make an AND statement used for setting variables or including parameters for a command. Athul Prakash age 16 at the time gave a logical idea for how to implement an OR test by negating the conditions in IF statements and then using the ELSE clause as the location to put the code that requires execution.

I thought to myself that there are however two else clauses usually needed since he is suggesting using two IF statements, and so the executed code needs to be written twice. In my example, someone is allowed to drive a tank if they have a tank licence OR they are doing their military service. Enter true or false at the two prompts and you will be able to see whether the logic allows you to drive a tank. I know that there are other answers, but I think that the mine is more simple, so more easy to understand.

Hope this helps you! Well, if you can perform 'AND' operation on an if statement using nested 'if's refer previous answers , then you can do the same thing with 'if not' to perform an 'or' operation. If you haven't got the idea quite as yet, read on.

Otherwise, just don't waste your time and get back to programming. Just as nested 'if's are satisfied only when all conditions are true, nested 'if not's are satisfied only when all conditions are false. This is similar to what you want to do with an 'or' operand, isn't it? Even when any one of the conditions in the nested 'if not' is true, the whole statement remains non-satisfied. Hence, you can use negated 'if's in succession by remembering that the body of the condition statement should be what you wanna do if all your nested conditions are false.

The body that you actually wanted to give should come under the else statement. And if you still didn't get the jist of the thing, sorry, I'm 16 and that's the best I can do to explain.

An alternative is to look for a unix shell which does give you logical operators and a whole lot more. You can get a native win32 implementation of a Bourne shell here if you don't want to go the cygwin route. A native bash can be found here. I'm quite certain you could easily google other good alternatives such as zsh or tcsh. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams?

Collectives on Stack Overflow. Learn more. Asked 11 years, 11 months ago. Active 16 days ago. Viewed k times. How would you implement logical operators in DOS Batch files? JoelFan JoelFan I submit for your viewing pleasure: pi. Add a comment. Active Oldest Votes. Just to improve your answer a bit It would store value "true " in the variable The 'or' condition you describe is slick and works great for a range of numbers, but what if I am comparing 2 independent values, and not a range?

Dat IF Exist File2. Ryan McClue 3 3 silver badges 18 18 bronze badges. Dave Jarvis Dave Jarvis This means if name is "Yakko" or "Wakko" or "Dot", then echo "Warner brother or sister". OR is slightly tricky, but not overly so. Timo Salmi Timo Salmi 3 3 silver badges 3 3 bronze badges.

Does not work. If I give it Stack, it echoes. If I give it Overflow, it does not - it should.