coffee_machine
Reputation: 1223
Add a column and populate it in a single transaction with Sql Server
I'm making an update script for a given data base. The script must
- Update various things
- Add a column to a table
- Update various things
- Populate this column with specific values (based on various calculations done in C#)
- Update various things
The script must either succeed or fail AND leave the database unchanged.
My idea was to do it in a single transaction, but I get an error when populating the column:
This operation conflicts with another pending operation on this transaction.
Any idea?
Upvotes: 0
Views: 330
Answers (1)
TomTom
Reputation: 62093
No, no way. Sorry, You requirements are not cmopatible with the way SQL Server requires DML statements to be isolated.
Upvotes: 2
Related Questions
- Using transaction on a single update statement
- SQL Server INSERT INTO using transaction
- SQL Server - ALTER TABLE and INSERT in same transaction
- Create column and insert into it within the same transaction?
- Update a Column When Inserting a Record in SQL Server
- Add column to table and then update it inside transaction
- How to insert/update a separate row for each column with SQLServer
- Add column and update it within a transaction
- How can I copy one column to from one table to another in SQL Server
- Insert and update in the same transaction