Information générale
Forum:
Microsoft SQL Server
Titre:
Return concatenated string from select statement
I would like to return a concatenated string from a select statement rather than a series of records.
I realise I can just return a table and then convert it into to string myself, but I wondered if there was a SQL Server way of doing this, that return the string as some sort of scalar value.
at present I would have to do the following
Select myfield from mytable
mystring=''
for i = 1 to reccount
mstring = myfield + chr(13)
move to next record
next i
I am trying to remove the code loop above
Many Thanks
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement