How does SQL server insert data parallelybetween applications? : Suppose I have two applications.
One insert data into database continuously like it is having an infinity loop.

Now when the second application inserts data to same database and table what will happen.

If it waits till the other application to complete inserting which will handle this?

Or it will say it is busy?

Or code throws an exception?