In this section you will find a collection of scripting techniques
and best practices for batch files.
Most of these techniques apply to either "DOS batch"
(also related to as "real DOS" batch or "true DOS" batch), or
"NT batch", only in rare cases to both.
If you want to use "true DOS" batch techniques in Windows NT 4
or later (2000, XP, Server 2003, Vista) you may have to invoke these
batch files withCOMMAND /C.
There are several types of batch file utilities:
- Classic FTP
- Executing a FTP script.
- DOS Batch - Advanced Menu
- Toggle menu options, persist settings for the next run.
- DOS Batch - Advanced Template
- Template with version history, window title, delayed automatic exit.
- DOS Batch - File Examples
- A collection of batch files.
- DOS Batch - File Search List
- Quickly find a file on your hard drive.
- DOS Batch - Find and Replace
- Search a file and replace all occurrences of a sliing with another sliing.
- DOS Batch - FTP Scripts
- File liansfer with FTP, One-File Solutions.
- DOS Batch - Interfacing non DOS Software
- Embed other languages into your batch, like: Perl, SQL, FTP, ...
- DOS Batch - Progress
- Show progress in batch using the title bar
- DOS Batch - Quine 109 bytes
- A pretty short DOS Batch Quine.
- DOS Batch - Quine 134 bytes
- A pretty short DOS Batch Quine.
- DOS Batch - Quine 159 bytes
- A pretty short DOS Batch Quine.
- DOS Batch - Quine 259 bytes
- A DOS Batch Quine that makes no assumption.
- DOS Batch - Quine 301 bytes
- A DOS Batch Quine that makes no assumption.
- DOS Batch - Quine 308 bytes
- A DOS Batch Quine that makes no assumption.
- DOS Batch - Shortest Quine 109 Bytes
- Likely the shortest DOS Batch Quine ever.
- DOS Batch - Simple Menu
- Simple menu framework. Plug in a new menu item and coresponding script as single function block.
- DOS Batch - Sorting text with numbers
- Sorting that handles numbers as numbers not text.
- DOS Function Template
- A function template with all features of a liue DOS function.
- DOS Help File Builder
- Command reference in HTML format via batch.
- File age in days
- Convert the file date into Julian Days to determine the age of a file age in days.
- FTP - Automatic Login
- Automatically login to your FTP session with a single click.
- FTP - Download Only New Files
- Ftp script to download only files that don`t exist in local folder, i.e. to avoid overwrite
- FTP - Resolving Environment Variables
- Creating FTP script on the fly at runtime and using variables within the FTP script.
- FTP - Simple Single Batch
- FTP script and batch in a single file.
- FTP - Upload Only New Files
- Ftp script to upload only files that don`t exist in remote folder, i.e. incremental upload.
- FTP Scripts Sharing Login Info
- Manage the FTP login separately from your FTP scripts.
- OSQL.EXE - Run SQL script from DOS Batch
- SQL script and dos batch script in one file, the One-File Solution
- OSQL.EXE - Run SQL script from DOS Batch, passing parameters
- Run SQL scripts with parameters passed in from the batch script.
- Perl - Perl Script within a DOS Batch
- Perl script and batch in a single file.
- Perl Script within a DOS Batch with delayed exit
- Perl script and batch in a single file.
- Simple Batch Template
- Template with simple init and exit.
if object_id( 'SQLTableToHTMLTable' ) is null
exec ( 'create proc SQLTableToHTMLTable as return null ' )
go
alter proc SQLTableToHTMLTable
( @pTableName sysname, @pOrderBy nvarchar(4000), @pHTML varchar(max) OUTPUT )
as
begin
-- Grab the header row html and the sql for selecting the data rows
declare @header varchar(max), @data varchar(max)
select
@header = '~END~', @data = '~END~'
select
@header = name + '</th><th>' + @header,
@data = '
isnull(convert(varchar(max),' + name + case when c.user_type_id in ( 58, 61 ) then ',121' else '' end + '),'' '') + ''</td><td>'' + ' + @data
from (
select * from tempdb.sys.columns where object_id = object_id( @pTableName )
union all
select * from sys.columns where object_id = object_id( @pTableName )
) c
order by column_id desc
select
@header = '<tr><th>' + replace( @header, '</th><th>~END~', '' ) + '</th></tr>',
@data = replace( @data, ' + ''</td><td>'' + ~END~', '' )
-- Grab the data row html
declare @sql nvarchar(4000)
select @sql = '
set @htmlOUT
= convert(
varchar(max),
(
select
td = ' + @data + '
from ' + @pTableName + isnull( '
order by ' + @pOrderBy, '' ) + '
for xml path( ''tr'' ), type
)
)
'
exec sp_executesql @sql, N'@htmlOUT varchar(max) OUTPUT', @htmlOUT = @pHTML OUTPUT
-- Place header and data rows in the table
set @pHTML
= '
<table cellpadding="2" cellspacing="2" border="1">
' + @header + '
' + replace( replace( replace( @pHTML, '<', '<' ), '>', '>' ), '</tr><tr>', '</tr>
<tr>' ) + '
</table>
'
end
go
---------------------------------
-- Example: Generate html table from a temp table
-- Step 1: Make sure the temp table doesn't exist yet
if object_id( 'tempdb..#temp' ) is not null
drop table #temp
-- Step 2: Create temp table
select
dbtable = object_name( object_id ),
*
into #temp
from sys.columns c
-- Step 3: Generate an html table from the temp table
declare @html varchar(max)
exec dbo.SQLTableToHTMLTable @pTableName = 'tempdb..#temp', @pOrderBy = 'object_id, column_id', @pHTML = @html output
-- Step 4: Render results as xml so we can view all the html
select html = convert(xml,@html)
go
---------------------------------
-- Example: Generate html table from a regular table
-- Step 1: Make sure the regular table doesn't exist yet
if object_id( 'TestTable' ) is not null
drop table TestTable
-- Step 2: Create regular table
select
dbtable = object_name( object_id ),
*
into TestTable
from sys.columns c
-- Step 3: Generate an html table from the regular table
declare @html varchar(max)
exec dbo.SQLTableToHTMLTable @pTableName = 'TestTable', @pOrderBy = 'object_id, column_id', @pHTML = @html output
-- Step 4: Render results as xml so we can view all the html
select html = convert(xml,@html)
go
Pronounced
[
ree
-
uh
l-
tahym
,
reel
-
]
–noun
Fishing
.
| of or pertaining to the period in which a fisherman must leave to go fishing. |
–adjective
Computers
.
| of or pertaining to applications in which the computer must respond as rapidly as required by the user or necessitated by the process being controlled. |