I found this post by Ben Nadel when I was looking for a way to delete the rows in a table based on a foreign key column. I needed this to clear answers provided by a particular user in an online quiz I was developing. It was a real timesaver – the other options were to delete entries manually (ugh!) or write some long ugly code with nested select statements.
Related Posts
Unresolved Assembly Reference when Merging Precompiled ASP.NET Assemblies
If you need to merge the output DLLs generated after precompiling an ASP.NET website from Visual Studio 2008 and later, you need to use the ASP.NET merge tool. The location of this tool is a bit tricky, though. The version in the default location is actually the wrong one!
Accessing the VMware BIOS Screen at startup
Fortunately, there is a configuration setting that will give you more time to enter the BIOS screen at startup. It will make the POST screen delay for the specified number of milliseconds.
Reading a Binary XML stream in WCF
If you don’t provide a dictionary to read the XML stream with, you will get a weird and unhelpful exception that says “the input source is not correctly formatted”, and googling around will only bring you to posts telling you that “your client/server endpoints are not matched” or “you need to use the basicHttpBinding”. This is not a binding issue – it’s a deserialization issue that comes up when i make an attempt to inspect the soap messages coming in to (or going out of) my WCF service.
Specifing the bridging network adapter in vmware player 4
For those of you using VMware Player 4 on linux hosts, if you’re not happy with the autobridging for the vmnet0 network, you can choose a specific…
How TestDisk and the GParted LiveCD saved my deleted partitions
I was messing around with Vmware converter (in windows XP, running from a dual-boot partition), and then I kept getting the following message: “FAILED: Unable to find…
Reset Forgotten Local Administrator Password on Windows
Where angels fear to tread, fools rush in. I happily removed my computer from the domain and restarted Windows 7. When the computer came back up, I couldn’t login with my domain user account – which was not surprising. However, I could not log in with the local admin account either! I had reset the password like 6 months ago and forgotten about it. Now I couldn’t log in to the computer, and no one could help me remotely.