Browse by Tags

All Tags » parsename (RSS)

Splitting csv to columns

Suppose you have string in csv format and want to split into seperate columns. You can use parsename function as long as you have maximum four values. The following would work for any number of values declare @s varchar ( 2000 ), @data varchar ( 2000...
Posted by Madhivanan | 5 comment(s)