I am constantly needing and forgetting the syntax for this function. Finally, if I put it here, I'll have quick and easy access to it:
SELECT COALESCE(@column1 + ',', '') + column1
FROM Table1
Subscribe to:
Post Comments (Atom)
skip to main |
skip to sidebar
Welcome to my technical blog. Here, I attempt to distill the Microsoft Certified Professional Developer knowledge I have accumulated since first qualifying MCP in 1996. This blog started on 13 September 2007 as an off-shoot from my mixed up personal blog. But it took a shot in the arm from Scott Hanselman's talk at TechEd New Zealand 08 "32 Ways To Make Your Blog Suck Less". I moved it across to Blogger from GeekZone in July 2009.
No comments:
Post a Comment