Monday, July 2, 2007

Replicate function in SQL Server 2005

The replicate function in SQL Server 2005 is used to replicate a specific value for a provided number of times. For example the following query,

select replicate('Sabah ',10) as [Replicate Test]

Results:

Sabah Sabah Sabah Sabah Sabah Sabah Sabah Sabah Sabah Sabah

1 comment: