|
|
|
|
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. |
|
|
|
|
|
List of SQL Server error messages from 1 to 500 together with links on certain error messages on how to solve or work
around these error messages. |
|
|
List of SQL Server error messages from 501 to 1000 together with links on certain error messages on how to solve or work
around these error messages. |
|
|
List of SQL Server error messages from 1001 to 1500 together with links on certain error messages on how to solve or work
around these error messages. |
|
|
List of SQL Server error messages from 1501 to 2000 together with links on certain error messages on how to solve or work
around these error messages. |
|
|
List of SQL Server error messages from 2001 to 3000 together with links on certain error messages on how to solve or work
around these error messages. |
|
|
List of SQL Server error messages from 3001 to 4000 together with links on certain error messages on how to solve or work
around these error messages. |
|
|
List of SQL Server error messages from 4001 to 5000 together with links on certain error messages on how to solve or work
around these error messages. |
|
|
List of SQL Server error messages from 5001 to 6000 together with links on certain error messages on how to solve or work
around these error messages. |
|
|
List of SQL Server error messages from 8001 to 8500 together with links on certain error messages on how to solve or work
around these error messages. |
|
|
|