SQL Server: Insert rows in a table and at the same time retrieve the id inserted with only a single statement? the OUTPUT and the OUTPUT INTO clauses
![Multi-tenant processing pipelines with AWS DMS, AWS Step Functions, and Apache Hudi on Amazon EMR | AWS Big Data Blog Multi-tenant processing pipelines with AWS DMS, AWS Step Functions, and Apache Hudi on Amazon EMR | AWS Big Data Blog](https://d2908q01vomqb2.cloudfront.net/b6692ea5df920cad691c20319a6fffd7a4a766b8/2020/11/13/Multi-tenant-processing-pipelines-1.jpg)
Multi-tenant processing pipelines with AWS DMS, AWS Step Functions, and Apache Hudi on Amazon EMR | AWS Big Data Blog
![SQL Server: Working with Identity Column After Table Creation - TechNet Articles - United States (English) - TechNet Wiki SQL Server: Working with Identity Column After Table Creation - TechNet Articles - United States (English) - TechNet Wiki](http://social.technet.microsoft.com/wiki/cfs-file.ashx/__key/communityserver-wikis-components-files/00-00-00-00-05/2185.3.png)