---
title: "同数据表内数据的复制（mssql语句）"
author: "java_cache"
date: "2013-06-08T15:19:44Z"
tags: []
categories: ["数据库"]
slug: "mssql"
draft: false
lastmod: "2013-06-08T15:19:44Z"
id: 1884433
url: "https://java-cache.iteye.com/blog/1884433"
---

复制到某个唯一标识下:

insert into table (d1,d2,d3) select d1,xxxx,d3 from table where d2=3