I have a stored procedure that inserts some values to a specific table:

```
CREATE PROCEDURE AccessoiresAddOrder
    @AccessoireID int,
    @Qte int,
    @ClientID int,
    @Price Varchar(50),
    @Totalprice Varchar(50),
    @Date DateTime,
    @ValueInt
AS
    INSERT INTO [dbo].[Accessoires_Orders] ([AccessoireID], [Qte], [ClientID], [Price], [Totalprice],[Date])
    VALUES (@AccessoireID, @Qte, @ClientID, @Price, @Totalprice, @Date)

    INSERT INTO [dbo].[Accessoires_ordervalue] (Value) 
    VALUES (@Value)

```

The `Acccessoires_Orders` table has a column `ID` which is "auto identity". Is there any way to get that value during the procedure execution?

```
int ID = Max(Accessoires_Orders.ID) + 1

```

Why ?

Because this procedure can be executed by multiple users at the same exact time.