Click here to Skip to main content
Click here to Skip to main content
Add your own
alternative version

Tagged as

Go to top

Select a column in a comma separated row in SQL

, 10 May 2011
Nice one but it did not handle null values you can change it as following to handle null valuescreate table #TABLE_1 (COLUMN_1 varchar(5))insert into #TABLE_1select 'A'union allselect 'B'union allselect 'C'union allselect 'D'union allselect 'E'union allselect...

Statistics


License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

code in play
Software Developer (Senior)
India India
4+ year experience in Microsoft technologies(C#.Net,ASP.Net, SQL server and Sharepoint).
Follow on   Twitter

| Advertise | Privacy | Mobile
Web04 | 2.8.140926.1 | Last Updated 11 May 2011
Article Copyright 2011 by code in play
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid