Functions System

Learn various ways you can use the SQL Coalesce function to pivot data, generate multiple SQL statements and more.

In this article we look at how to query for a list of random data from a SQL Server table by using TABLESAMPLE clause.

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

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.