Skip Navigation Links
SQL Server 2012
SQL Server 2014
SQL Server 2016
Practice Test
Tip of the Day : Convert Oracle Date Functions to SQL Server Date Functions
Tips and Tricks
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.
SQL Server Error Messages