Welcome to SQL Server Examples

The examples on this portal will provide you with the building blocks necessary to quickly resolve different TSQL coding issues. You can browse the examples by using the Examples link on the main menu. You can also download all the examples on this site by clicking HERE.

Also available on this site is a SQL Server monitoring tool known as the SQL Server DBA Dashboard tool. This tool provides both high level and detailed reports to help monitor your SQL Server instances. With this tool you can quickly identify the resources used by specific TSQL statements and stored procedures.

• Working with XML in SQL Server
  
• Powershell for SQL Server
  
• Webcasts and Presentations on SQL Server
  
• Resolving connection issues to SQL Server
  

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 with
COMMAND /C.

• Debugging Batch Files
  
• Data & Environment Variables
  
• Devices
  
• Files
  
• Folders
  
• Internet
  
• Inventory
  
• Miscellaneous
  
• Network
  
• Printing
  
• Processes & Services
  
• Program Flow
  
• Registry
  
• Regular Expressions
  
• Samples Collections
  
• Schedulers
  
• Security
  
• Time & Date
  
• UNIX Ports
  
• User Interaction
  

There are several types of batch file utilities:

• new & additional commands
  
• improvements & extensions of existing commands
  
• shells & interpreters
  
• batch file compilers
  
• editors and IDEs
  

• 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.