if object_id(‘tb’) is not null drop table tb;goCREATE TABLE tb(yearid int,[population] int,income int)goinsert into tb(yearid,[population],income)select 2010 本文来源gaodai#ma#com搞@代~码^网+as id,100000 as population,123456 as incomeunion all select 2011,110000,1346000un
if object_id(‘tb’) is not null drop table tb;goCREATE TABLE tb(yearid int,[population] int,income int)goinsert into tb(yearid,[population],income)select 2010 as id,100000 as population,123456 as incomeunion all select 2011,110000,1346000union all select 2012,115000,1200000union all select 2013,120000,1500000
,