declare @retstr varchar(8000) select Top 5 @retstr = COALESCE(@retstr + ';','') + City from State print @retstr
Subscribe to:
Post Comments (Atom)
Update the author and email address of every commit on a repository
source: stackoverflow.com
-
You suppose you are wanted to add a string to a page that the string has to have a hyperlink in it to link a particular page for any reason....
-
Sample table as Cities in rows is convert to single column declare @retstr varchar(8000) select Top 5 @retstr = COALESCE(@retstr + ...
-
Have you ever launched SQL Server Management Studio (SSMS) and had to wait over 60 seconds before you could even log in? I have - all too ...
No comments:
Post a Comment