删除临时表并且插入数据

if object_id('tempdb..#temp') is not null drop table #temp
go
create table #temp
(
id int,code nvarchar(6),name nvarchar(50),provinceId nvarchar(6)
)
insert into #temp select id,code,name,provinceid from City1

select * from #temp