Search results for query: *

I have an app that semi-recently converted to being database driven, this C++ app is an asset editor that knows about all of our assets and lets you edit any of them. In some situations a user will open the app, they will claim lets say 200 assets to edit and edit them, but when they save them...

I am not really sure I am following your question. In your example if Column "One" is 2 then you want to set Column "Two" to True. But if Column "Two" is 3 then you want to update Column "Three" to True else NULL. Column "Two" in your example is both of type int and of type bit? Regardless...

There are no cursors, we originally had some cursors for something else and when we hit the deadlocking we worked around them "just in case" (was easy to convince us since no one seems to like them). Numbers of dependencies could vary from 0 to 5000 (estimated), I understand this one deffinately...

So.. I think I went about my question wrong last time so I am revisiting this with something way more focused and see if anyone can enlighten me. I have the following two transactions going on at the same time by different clients. Revert --Ex: Asset 1234, version 2 which has a metadata id of...

I am not sure I explained things well the first time. So, I am not sure what you mean by thinking I dont have to update my foreign key. As far as the Dependencies retrieval information: I think you are reffering to our Delete all Dependencies associated with a metadata_id Insert all...

Hi there, I am a bit new to all of this and have had my first run in with a deadlock situation. We know what is causing the deadlock but are unsure what the best solution is to fix the problem. In our simplest case we have the following tables with three common transactions on them...