sql - How to obtain SCOPE_IDENTITY() from INSERT run in EXEC ...

2012年9月6日 - The SQL insert works fine but when I execute SET @Record_ID ... SELECT @Id = SCOPE_IDENTITY()' EXECUTE sp_executesql @sql, N'@Id ...

stackoverflow.com