首页 > 技术文章 > Sql sever 新增并返回自增长ID

lhlong 2018-05-30 15:26 原文

 

 

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;

  

推荐阅读