MSSQL中使用旧表创建新表

使用旧表t_tbale创建新表t_newtable

select *  into t_newtable from t_table.  这个带数据，并且创建后的无主键

select top 0 * into testAAA FROM tbl_User --sqlserver方法一复制表结构 无主键  select F_AreaId,F_ParentId into LR_Base_Area4 
from LR_Base_Area where 1=1 ;
无主键

select * into testAAA FROM tbl_User --sqlserver复制表结构和数据 INSERT INTO testAAA SELECT * FROM tbl_User --sqlserver复制数据 CREATE TABLE testB SELECT * FROM testa limit 0; mysql复制表结构 CREATE TABLE testC SELECT * FROM testa           
mysql复制表结构并复制数据 INSERT INTO testB SELECT * FROM testa  MySQL复制数据
还有一种方法create table if not exists good LIKE lee 
创建像表Lee一样结构的good表 select ROW_NUMBER()over(  partition by officeid order by userid )as id, * from tbl_User  
sqlserver中表示根据officeid分组 然后根据userid排序 select ROW_NUMBER()over( order by officeid )as id, * from tbl_User  根据officeid排序  

update SL_activityOrderMain set SL_activityOrderMain.UserPhone = SL_activityOrderDetail.UserPhone
from SL_activityOrderDetail inner join SL_activityOrderMain on SL_activityOrderDetail.OrderMainID
= SL_activityOrderMain.F_Id where SL_activityOrderMain.UserPhone is null