values (10,715)


sql - Swap unique indexed column values in database

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…


language agnostic - Followup: Finding an accurate “distance” between colors

Original Question I am looking for a function that attempts to quantify how "distant"(or distinct) two colors are. This question is really in two parts: What color space best represents human visi…


sql - What is the best way to handle multiple permission types?

I often encounter the following scenario where I need to offer many different types of permissions. I primarily use ASP.NET/VB.NET with SQL Server 2000. Scenario I want to offer a dynamic permissio…


c# - CSV File Imports in.Net

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, argument…


How do I use T-SQL Group By

I know I need to have(although I don't know why) a GROUP BY clause on the end of a SQL query that uses any aggregate functions like count, sum, avg, etc: SELECT count(userID), userName FROM users GR…


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…


c# - DataTable Loop Performance Comparison

Which of the following has the best performance? I have seen method two implemented in JavaScript with huge performance gains, however, I was unable to measure any gain in C# and was wondering if the…



SQL Case Expression Syntax?

What is the complete and correct syntax for the SQL Case expression?…


c# - Numeric Data Entry in WPF

How are you handling the entry of numeric values in WPF applications? Without a NumericUpDown control, I've been using a TextBox and handling its PreviewKeyDown event with the code below, but it's pre…


language agnostic - How do you handle huge if-conditions?

It's something that's bugged me in every language I've used, I have an if statement but the conditional part has so many checks that I have to split it over multiple lines, use a nested if statement o…




how value multiple from with get array list string column