表的复制copy

整个表的复制
Insert into user2.dbo.client
Select * from user1.dbo.client

复制表的结构
select * into [default1]
from [default]
where 1<>1

复制表的前2000条记录
select top 2000 * into [TA_SA_USER]
from [member]