Sql sever 新增并返回自增长ID

 

 

SELECT @@IDENTITY AS ID;

INSERT INTO T_KakouhinNyuko_H 
(JyuchuNo,JyuchuGyoNo,KannriNo,CommodityNo,WarehousesCode,OperatorID,InsDateTime) VALUES 
('1','1','1','1','1','1',GETDATE())
SELECT @@IDENTITY AS ID;