update (14,172)


Throw an error in a MySQL trigger

Throw an error in a MySQL trigger

If I have a trigger before the update on a table, how can I throw an error that prevents the update on that table?…


SQL Server 2005 implementation of MySQL REPLACE INTO?

MySQL has this incredibly useful yet properitary REPLACE INTO SQL Command. Can this easily be emulated in SQL Server 2005? Starting a new Transaction, doing a Select() and then either UPDATE or INSERT…


sql - Swap unique indexed column values in database

I have a database table and one of the fields(not the primary key) is having a unique index on it. Now I want to swap values under this column for two rows. How could this be done? Two hacks I know ar…


c# - Automatically update version number

I would like the version property of my application to be incremented for each build but I'm not sure on how to enable this functionality in Visual Studio(2005/2008). I have tried to specify the Assem…


sql server - Editing database records by multiple users

I have designed database tables(normalised, on an MS SQL server) and created a standalone windows front end for an application that will be used by a handful of users to add and edit information. We…



What are your favorite Powershell Cmdlets?

I just found/n softwares free Powershell NetCmdlets, and after playing with them I love the functionality they bring to the command line. So it raises the question what are your favorite Cmdlets, a…


Can ASP.NET AJAX partial rendering work inside a SharePoint 2007 application page?

I have a simple page with my ScriptManager and my UpdatePanel, and my ContentTemplate has one ListBox and one Label. I am just trying to catch its OnSelectionChanged so I can update the text in the…


Multiple Updates in MySQL

I know that you can insert multiple rows at once, is there a way to update multiple rows at once(as in, in one query) in MySQL? Edit: For example I have the following Name id Col1 Col2 Row1 1 6 1 Row2…


Integrating Fogbugz with TortoiseSVN with no URL/Subversion backend

I've got TotroiseSVN installed and have a majority of my repositories checking in and out from C:\subversion\ and a couple checking in and out from a network share(I forgot about this when I origina…


Automated release script and Visual Studio Setup projects

I think most people here understand the importance of fully automated builds. The problem is one of our project is now using an integrated Visual Studio Setup project(vdproj) and has recently been p…




how example not from for with insert data query get