SQL 数据库复制一行数据

SQL 数据库复制一行数据
简单写法：

insert into table1 select * from table1 where ...

　带上详细字段

insert into Table1(Field1, field2, id)
    select field1, field2, uId from Table1 where uId = @Id;