With SQL Server 2022, INSERT INTO ... OUTPUT.Inserted.* VALUES ... can get the inserted items. Then statement can insert data into one or two tables(with same table structure).

With SQL Server 2022, INSERT INTO ... OUTPUT.Inserted.* VALUES ... can get the inserted items. Then statement can insert data into one or two tables(with same table structure).

I used this code to convert date to “Arabic” culture

I have table Machine and table Inventory. In table Machine, I have last running inventory properties. In table Inventory, I have new inventory id and properties (Not yet run in machine).
I have to return a list of possible combination inventory that can run in machines based on it last running inventory. And I also need to return list of machines with no duplicates inventory.

I’m new to MS SQL Server and am trying to write C++ code to access entries in my database.

I made an application in c# and on my local computer the connection string I had was