我插入一个表然后取回ID以便我可以插入另一个表的正常过程在MSSQL中是这样的:DECLARE@transactionKeyuniqueidentifierSET@transactionKey=NEWID()INSERTINTOtransactions(transactionKey,transactionDate,transactionAmount)VALUES(@transactionKey,'#transactionDate#','#transactionAmount#')DECLARE@transactionIDintSELECT@transactionID=transactio

我插入一个表然后取回ID以便我可以插入另一个表的正常过程在MSSQL中是这样的:DECLARE@transactionKeyuniqueidentifierSET@transactionKey=NEWID()INSERTINTOtransactions(transactionKey,transactionDate,transactionAmount)VALUES(@transactionKey,'#transactionDate#','#transactionAmount#')DECLARE@transactionIDintSELECT@transactionID=transactio