Sql 语法: 插入多行记录 Insert Into TableName1 ( column1 ,column2 ) Select column1,column2 From TableName2 Insert Into TableName ( column1,column2 ) Values ( value1,value2 ) , ( value3,value4 ) 1.返回刚添加的行的自增ID SQL code insert into tableA(d,e,f,g)values('aa','dd','ff','gg') select @@identity 2.获取当前插入表1的ID SQL code select max(c) from table1 3.使用declare SQL code declare @sql varchar(200) set @sql='inser into table2(lessonId,currentTime,date,beginTime,endTime)' select @sql=@sql+'values('+Convert(varchar(10),max(c))+',10,''20110520'',''20110520'',''20110521'')' from table1 --print @sql exec(@sql)