Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
Clages1
Yak Posting Veteran
69 Posts |
Posted - 2013-05-03 : 13:04:12
|
Hi, i am trying to get all rows from one table into a Varchar(max)my table has one column varchar(800)sampleaaaaaaaaaaabbbbbbbbbbbccccddddddddeeeeeeeeeeetcdeclare @x varchar(max)i would like to get this@x= aaaaaaaaaaabbbbbbbbbbbccccddddddddeeeeeeeeeeI know how to do using cursor..is there anote option without a cursor?tksCarlos LagesDec |
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-05-03 : 13:33:09
|
[code]SELECT colname AS [text()] FROM YourTable FOR XML PATH('');[/code] |
|
|
|
|
|