JerryFei</br>的自留地

SELECT extra FROM information_schema.columns WHERE TABLE_SCHEMA=‘数据库名’ AND table_name = ‘表名’ AND column_name=‘字段名’ 是自增如下结果，否则EXTRA 为空

1.返回刚插入的记录的Id      INSERT #(Name) OUTPUT INSERTED.ID INTO @T          SELECT TOP 10 Name FROM Table    2.批量插入：      insert into Orders(表一)(OrderId,BookId,UserId,TotalPrice)         select orderId