-清空表所有数据

--创建临时表
select * into tempprovince from dbo.m_province
select * into tempcity from dbo.m_city
select * into temparea from dbo.m_area
select * into tempcustomer from dbo.t_customer
select * into 目标表名 from 源表名

select * from dbo.m_province
select * from dbo.m_city
select * from dbo.m_area
select *from dbo.t_customer

--清空表所有数据 
truncate   table   表名 
truncate table  dbo.m_province
truncate table dbo.m_city
truncate table dbo.m_area
truncate table dbo.t_customer