SQL插入换行符和格式化数据

我相信你可以用接线员。
http://www.tizag.com/sqlTutorial/sqlcase.php

  SELECT CASE WHEN Video_Title IS NOT NULL THEN
       Video_Title + '\n'
       ELSE
       ''      
       END + 

       CASE WHEN Author IS NOT NULL THEN
       Author + '\n'
       ELSE
       ''   
       END +


       CASE WHEN URL IS NOT NULL THEN
       URL + '\n'
       ELSE
       ''   
       END   
FROM Videos

这是我刚用自己的数据库尝试过的东西,但我认为这样的东西应该能起到作用:)

DECLARE @CRLF CHAR(2)

SET @CRLF = CHAR(10)+ CHAR(13);

WITH t AS
(
SELECT 'A' AS A,'B' AS B, 'C' AS C, 'D' AS D, 'E' AS E UNION ALL
SELECT 'A' AS A,NULL AS B, NULL AS C, NULL AS D, 'E' AS E UNION ALL
SELECT NULL AS A,NULL AS B, NULL AS C, NULL AS D, NULL AS E
)
SELECT 
ISNULL(STUFF(ISNULL(@CRLF + A,'') + ISNULL(@CRLF + B,'') + ISNULL(@CRLF + C,'') + ISNULL(@CRLF + D,'') +ISNULL(@CRLF + E,'')  , 1, 2, ''),'')
FROM t