MSSQL2008中执行通过
一、别再foreach一条条插数据了,累啊!
CREATE TABLE [dbo].[tb1](
[t1] [int] IDENTITY(1,1) NOT NULL,
[t2] [int] NULL,
[t3] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
insert into tb1 (t2,t3)values(1,'1'),(2,'2'),(3,'3')
SELECT TOP 1000 [t1]
,[t2]
,[t3]
FROM [Test1].[dbo].[tb1]
二、英雄无用武之地啊
insert into tb1 (t2,t3)
select t2,t3 from tb1