![]() ![]() RAISERROR(‘– %s %d and stuff here’,0,-1, WITH NOWAIT To see more of these, follow me on Twitch or YouTube.Īs an alternative (and if you do not need to control the lock escallation as much), I have tended to do batched updates as an old fashioned label loop (I come form the heady days of SQL 4.21a when fancy cte’s and young whipper snapper things did not exist :-)) ) and this works well when I have to trickle updates, dels & inserts – the approach also means I do not usually need any staging logic and if the update is kicked out from deadlocking or errors it can be restarted without any remedial work in the code.įeel free to use, ignore, laugh at ( ho ho ho we dont use that old Grandpa technique anymore) Or, if you’d like to watch me write this blog post, I did it on a recent stream:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |