整个表的复制
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]
整个表的复制
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]