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,BookId,UserId,UnitPrice from Cart(表二)
inner join Books On(Cart.BookId=Books.Id) where Cart.UsrId="xxx"
3.一般插入
insert into 表名(表列名) values(对应表列名的属性值)