Computed Columns in SQL Server 2005

Using Persited Columns in SQL Server 2005 via t-sql and sql server management studio

Concatenating column values in SQL Server 2000/2005

If you want to concatenate values from a specific column like for example: Table=====1    One2    Two3    Three4    Four to the following: Output======One, Two, Three, Four Here is a simple way to do it: SQL Server 2005: SELECT STUFF(SELECT ‘, ‘ + ColumnName FROM TableName FOR XML PATH(”),1,2,”) SQL Server 2000: DECLARE @t varchar(4000)SET @t = [...]