|
|
Return a comma-separated value without the use of cursors. |
|
|
Easily identify missing identity values in your table. |
|
|
An alternative to SQL Server's RAND mathematical function. |
|
|
Generate a certain number of random records from any of your tables. |
|
|
Sort IP addresses that are stored as VARCHAR by their numeric values. |
|
|
Different ways of splitting a full name to get the first name and last name. |
|
|
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 located in a specific directory without having
to manually open each .sql script and executing them in Query Analyzer. |
|
|
Provides a list on how to convert datetime values into different date formats. |
|
|
Shows the differences between using the SET command and the SELECT statement when assigning a value to a local variable. |