insert语句

set identity_insert TransportUnit ON--打开
insert 
into TransportUnit(ID,Code,MaterialID,TransportNo,MaterialType,Quantity)
values(1,1,1,1,'水泥',60)
insert 
into TransportUnit(ID,Code,MaterialID,TransportNo,MaterialType,Quantity)
values(2,2,1,1,'水泥',60)
insert 
into TransportUnit(ID,Code,MaterialID,TransportNo,MaterialType,Quantity)
values(3,3,2,2,'混合料',1)
insert 
into TransportUnit(ID,Code,MaterialID,TransportNo,MaterialType,Quantity)
values(4,4,2,2,'混合料',1)
select * from TransportUnit

上述语句是因为前四条语句没有了，故用insert语句从新的插入新的记录。