1、先写到临时表，SELECT ID-1 AS ID ,[内容]INTO #TempFROM ContentWHERE ID > 12、再update回原表UPDATE Content SET [内容] = T.[内容]FROM Content CJOIN #Temp T ON T.ID = C.ID
