Monthly Archives: April 2011

SQL server ALLTRIM()

Posted on April 11, 2011 by davidbridge

To trim leading spaces you can use LTRIM() and to remove trailing spaces you can use RTRIM() and to trim all you can use LTRIM(RTRIM(xxx)) but these functions do not account for non-printing characters that you may encounter when importing … Continue reading →

Posted in Developer stuff, SQL Stuff | Tagged , , , | 3 Comments

Persisted Computed Column Data Type

Posted on April 8, 2011 by davidbridge

If you create a computed column on a table and make it persisted then the column is calculated as the data is entered in to the database and therefore takes up space in the database. The value saved also determines … Continue reading →

Posted in Developer stuff, SQL Stuff | Tagged , , , , , , , | Leave a comment