实例1:insert into dbo.RoomType(表名)(TypeName,Price,AddBed,BedPrice,Remark) output inserted.ID values('kkk',321,1,25,'oooo')
实例2: insert into dbo.RoomType(表名)(TypeName,Price,AddBed,BedPrice,Remark) values('kkk',321,1,25,'oooo') select @@identity
实例1:insert into dbo.RoomType(表名)(TypeName,Price,AddBed,BedPrice,Remark) output inserted.ID values('kkk',321,1,25,'oooo')
实例2: insert into dbo.RoomType(表名)(TypeName,Price,AddBed,BedPrice,Remark) values('kkk',321,1,25,'oooo') select @@identity