Learn SQL Server functions with practical tips, examples, and tutorials to improve querying and data analysis.
I have started a new application where I need to start aggregating some of the data and perform some basic mathematical functions. I know I can perform some of the calculations in the front end application, but I am not sure this is the best approach in
Learn SQL date format options with the SQL CONVERT function when working with date data types in SQL Server.
Sometimes there is a need to get record counts from every table in your database. One way of doing this is to do a SELECT count(*) on all of your tables, but this could create a lot of overhead especially for large databases and large tables. If you don'
Sometimes there is a need to manipulate string values using T-SQL code. With other languages such as Visual Basic, C++, C#, VBScript, etc... there are a lot of commands at your finger tips. With SQL Server 2000 you don't have all the same options, but t
Determining if two rows or expressions are equal can be a difficult and resource intensive. To address this need the CHECKSUM, CHECKSUM_AGG and BINARY_CHECKSUM functions are available in SQL Server 2005 to natively create a unique expression, row or table
In this tip we look at how to randomly retrieve a few records from a SQL Server table.