1021

0

Please login or register to vote for this query.

(click on this box to dismiss)

SharePoint

Q&A for SharePoint enthusiasts

SELECT
    q.Id AS QuestionId,
    q.Title AS QuestionTitle,
    q.Body AS QuestionBody,
    q.AcceptedAnswerId,
    q.AnswerCount,
    q.CommentCount,
    q.CommunityOwnedDate,
    q.CreationDate AS QuestionCreationDate,
    q.FavoriteCount,
    q.LastActivityDate AS QuestionLastActivityDate,
    q.LastEditDate AS QuestionLastEditDate,
    q.LastEditorDisplayName AS QuestionLastEditorDisplayName,
    q.LastEditorUserId AS QuestionLastEditorUserId,
    q.OwnerDisplayName AS QuestionOwnerDisplayName,
    q.OwnerUserId AS QuestionOwnerUserId,
    q.Score AS QuestionScore,
    q.Tags AS QuestionTags,
    q.ViewCount AS QuestionViewCount,
    a.Id AS AnswerId,
    a.CreationDate AS AnswerCreationDate,
    a.Score AS AnswerScore,
    a.Body AS AnswerBody
FROM
    Posts q
INNER JOIN
    Posts a ON q.AcceptedAnswerId = a.Id
WHERE
    q.PostTypeId = 1
    AND a.PostTypeId = 2
    AND q.Id IN (2517, 4944)  -- 여기에서 지정한 질문 ID들만 선택
ORDER BY
    q.CreationDate;

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results