复制通一张表的记录,并修改某个字段信息:
//复制记录
CString strsql ="INSERT INTO terminal(column1,column2) SELECT column1,column2 FROM terminal WHERE terminalname='"+::G_Term+"'";
((static_cast<CMyApp *>(AfxGetApp()))->g_pDb)->Execute(strsql);
//修改SELECT出来的记录的字段信息
strsql ="UPDATE terminal INNER JOIN (SELECT TOP 1 * FROM terminal WHERE terminalname='"+::G_Term+"') s ON terminal.ID=s.ID SET terminal.terminalname='"+orderTerm+"'";
((static_cast<CMyApp *>(AfxGetApp()))->g_pDb)->Execute(strsql);