c++ - 如何在另一个表中使用表的最后插入的 id

Question

我已经搜索并意识到我可以使用 SCOPE，但我不确定如何使用它。任何帮助将不胜感激

这是选项插入语句

char sql[256];
    sprintf_s(sql, "INSERT INTO Options[Value],[ValuesCorrect],[QuestionId]) VALUES ('%s', '%d', '%d'); " 
        , choice->getValue()
        , choice->getIsAnswer()
        , choice->getQuestionId());
        pRecordSet->Open(sql, pConnection.GetInterfacePtr(), adOpenForwardOnly, adLockReadOnly, adCmdText);

这是我的问题表

char sql[256];
    "DECLARE @ID = BIGINT";
    sprintf_s(sql, "INSERT INTO Questions([Query],[CompetencyLevel],[TopicId]) VALUES('%s', %d, %d); "
        ,(const char*)question->getQuery()
        , question->getCompetencyLevel()
        ,question->getTopicId());
    pRecordSet->Open(sql, pConnection.GetInterfacePtr(), adOpenForwardOnly, adLockReadOnly, adCmdText);
    "SELECT@ID = SCOPE_IDENTITY();";

Answer 1

下面的查询将返回插入的id

INSERT INTO Options (
    [Value]
   ,[ValuesCorrect]
   ,[QuestionId]
) 
OUTPUT inserted.[YourIdColumnName]
VALUES (
   '%s'
  ,'%d'
  ,'%d'
)

很久没用过 ADO 但代码看起来像这样

pRecordSet->Open(...);
auto id = pRecordSet->Fields->Item[0]->Value;