SELECT NEWS_ID,
CASE WHEN NEWS_DATA is not null THEN '(图)' || NEWS_TITLE ELSE NEWS_TITLE END NEWS_TITLE,
CASE WHEN NEWS_DATA is not null THEN NEWS_DATA ELSE '0' END NEWS_DATA,
NEWS_CONTENT || '(本文来源:' || ORIGIN ||')' AS NEWS_CONTENT, UPDATE_TIME
FROM NEWS_RES_LIST
WHERE NEWS_ID = 1+1
运行会报“字符集不匹配”的错误消息,把'0'前加n,或cast('0' as nchar)就可以了
CASE WHEN NEWS_DATA is not null THEN '(图)' || NEWS_TITLE ELSE NEWS_TITLE END NEWS_TITLE,
CASE WHEN NEWS_DATA is not null THEN NEWS_DATA ELSE '0' END NEWS_DATA,
NEWS_CONTENT || '(本文来源:' || ORIGIN ||')' AS NEWS_CONTENT, UPDATE_TIME
FROM NEWS_RES_LIST
WHERE NEWS_ID = 1+1
运行会报“字符集不匹配”的错误消息,把'0'前加n,或cast('0' as nchar)就可以了