wish help you to fix your issue I have a stored procedure that I want to use to create one row in a parent table [Test] and multiple rows in a child table [TestQuestion]. The parent and child table both have primary keys that are identity datatype. Here is what the child table looks like with some not relevant columns removed: , You can use Table variable parameter for your stored procedure :
CREATE TYPE GuidList AS TABLE (Id UNIQUEIDENTIFIER)
CREATE PROCEDURE test
@Ids dbo.GuidList READONLY
What is the syntax to define a Postgres procedure within an another stored procedure?
To fix this issue It's a property of your session rather than of a procedure. The procedure will use whatever the calling session already has, unless you override it within the procedure. Setting everything to READ UNCOMMITTED though is a big red flag. Unless you don't care about data consistency, you really don't want to do that. You can miss data, you can have duplicated data, etc. There's a reason it's not the default, and there are usually other ways to address whatever issue causes you to want to use it.