update after insert problem(thousands rows) | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

update after insert problem(thousands rows)

In Store procedure: 1. Insert thousands of rows to tableA. 2. Update the rows in tableA Immediately. can i do that in the store procedure?
Yes you can do that, what records you want to insert and update? give us some more information.. Chirag http://chirikworld.blogspot.com/
yes. You can do in SP. But why update after insert ? What is the update for ?
Why don’t you insert the correct information into the tableA in the first place ?
Thanks chiragkhabaria and khtan.
I solved that problem now, just make a mistake.