插入多条数据
insert [eastmoney数据库2].[dbo].[大盘开盘日]
select CONVERT(VARCHAR(30),realdate,111) 日期
from [eastmoney数据库2].[dbo].[大盘数据20110216] where CONVERT(VARCHAR(30),realdate,111)>'2009/10/30' and CONVERT(VARCHAR(30),realdate,111)<'2010/10/01' group by CONVERT(VARCHAR(30),realdate,111) order by CONVERT(VARCHAR(30),realdate,111) DESC
ID递增
CREATE TABLE [dbo].[大盘开盘日]( [日期] [varchar](30) NULL, [ID] [int] identity(1,1) primary key) ON [PRIMARY]
