| Comma-Delimited Output |
Return a comma-separated value without the use of cursors. |
| Determine Missing
Identity Values |
Easily identify missing identity values in your table. |
| Generate Random Numbers |
An alternative to SQL Server's RAND mathematical function. |
| Generate Random Records |
Generate a certain number of random records from any of your tables. |
| Sort IP Addresses |
Sort IP addresses that are stored as VARCHAR by their numeric values. |
| Split Name / Split String |
Different ways of splitting a full name to get the first name and last name. |
| Query/Read and Import an
Excel File |
Query/read and import an Excel file without using DTS and without loading the
data to a SQL table. |
| Execute a Batch of SQL Scripts |
Execute a batch of .sql scripts located in a specific directory without having
to manually open each .sql script and executing them in Query Analyzer. |
| SQL Server Date Formats |
Provides a list on how to convert datetime values into different date formats. |