SELECT * into #TMP FROM A WHERE counttime='2020-09-28 00:00:00'
UPDATE #TMP SET CountTime='20200927'
INSERT INTO aSELECT * FROM #TMP
DROP TABLE #TMP
SELECT * into #TMP FROM A WHERE counttime='2020-09-28 00:00:00'
UPDATE #TMP SET CountTime='20200927'
INSERT INTO aSELECT * FROM #TMP
DROP TABLE #TMP
本文标题:同一个表里的数据再复制一条
本文链接:https://www.haomeiwen.com/subject/xeifhltx.html
网友评论