Sign in | Join | Help

Madhivanan

This Blog

  • Home
  • Contact

Syndication

  • RSS
  • Atom
  • Comments RSS

Search

  • Go

Tags

  • alias name
  • Audits
  • backup
  • bcp
  • behaviour changes
  • coalesce
  • column length
  • count
  • Count words
  • Crosstab
  • csv
  • daily backup
  • data length
  • date
  • datetime
  • delete duplicate
  • dynamic crosstab
  • excel
  • export data
  • Export to Excel
  • export to Text
  • Extract numbers
  • free tool
  • functions
  • Generate sql script
  • image
  • Implicit conversion
  • import excel
  • IP address
  • ISDATE()
  • isnull
  • isnumeric
  • multiply
  • newid()
  • normalise
  • Nth Maximum
  • number
  • openrowset
  • pagination
  • parsename
  • PIVOT
  • procedure
  • procedures
  • random
  • random numbers
  • random password
  • Remove duplicates
  • row count
  • Row number
  • script
  • single quotes
  • split
  • sql server
  • sql to excel
  • sqlanswer
  • squeeze
  • store images
  • Stuff
  • table structure
  • tally number table
  • tempdb
  • time
  • Top columns
  • Truncate
  • T-sql
  • undocumented
  • union vs union all
  • WRITE

Navigation

  • Home
  • Blogs
  • Forums
  • Photos
  • Downloads

Archives

  • June 2008 (1)
  • May 2008 (2)
  • April 2008 (2)
  • March 2008 (1)
  • February 2008 (2)
  • January 2008 (2)
  • December 2007 (6)
  • November 2007 (7)
  • October 2007 (4)
  • September 2007 (1)
  • August 2007 (17)

Browse by Tags

All Tags » T-sql » parsename (RSS)
  • split
  • sql server
15 March 2008 10:57

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 | 3 comment(s)
Filed under: sql server, split, T-sql, parsename
Powered by Community Server (Commercial Edition), by Telligent Systems