April 24, 2007 - SQL Authority with Pinal Dave

SQL SERVER – TRIM() Function – UDF TRIM()

April 24, 2007

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Server does not have function which can trim leading or trailing spaces of any string. TRIM() is very popular function in many languages. SQL does have LTRIM() and RTRIM() which can trim leading and trailing spaces respectively. I was expecting SQL Server 2005 to have TRIM() function. Unfortunately, SQL…

SQL SERVER – Six Properties of Relational Tables

April 24, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Relational tables have six properties: Values Are Atomic This property implies that columns in a relational table are not repeating group or arrays. The key benefit of the one value property is that it simplifies data manipulation logic. Such tables are referred to as being in the “first normal form”…

SQL SERVER – 2005 Collation Explanation and Translation

April 24, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Collation

Just a day before one of our SQL SERVER 2005 needed Case-Sensitive Binary Collation. When we install SQL SERVER 2005 it gives options to select one of the many collation. I says in words like ‘Dictionary order, case-insensitive, uppercase preference’. I was confused for little while as I am used…