自己写的数据库视图中Case Then EXISTS例子

SELECT   dbo.Paper.Title, dbo.Paper.Summary, dbo.Paper.AttachmentUrl, dbo.Paper.AddedDate, dbo.Paper.KeyWord,
                dbo.Paper.ColumnId, dbo.ConColumn.ConferenceId, dbo.ConColumn.Name, CASE WHEN EXISTS
                    (SELECT   *
                     FROM      Review
                     WHERE   PaperId = dbo.Paper.Id) THEN '有' ELSE '无' END AS HasReview, dbo.Paper.Id
FROM      dbo.ConColumn INNER JOIN
                dbo.Conference ON dbo.ConColumn.ConferenceId = dbo.Conference.Id INNER JOIN
                dbo.Paper ON dbo.ConColumn.Id = dbo.Paper.ColumnId