columns (7,729)


c# - How do I get a distinct, ordered list of names from a DataTable using LINQ?

c# - How do I get a distinct, ordered list of names from a DataTable using LINQ?

I have a DataTable with a Name column. I want to generate a collection of the unique names ordered alphabetically. The following query ignores the order by clause. var names=(from DataRow dr in dataTa…


sql - Convert HashBytes to VarChar

I want to get the MD5 Hash of a string value in SQL Server 2005. I do this with the following command: SELECT HashBytes('MD5', 'HelloWorld') However, this returns a VarBinary instead of a VarChar valu…


What is a good web-based Grid that accepts Excel clipboard data?

Any good recommendations for a platform agnostic(i.e. Javascript) grid control/plugin that will accept pasted Excel data and can emit Excel-compliant clipboard data during a Copy? I believe Excel da…


sql - How do I split a string so I can access item x?

Using SQL Server, how do I split a string so I can access item x? Take a string "Hello John Smith". How can I split the string by space and access the item at index 1 which should return "John"?…


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…


How do I Concatenate entire result sets in MySQL?

I'm trying out the following query: SELECT A,B,C FROM table WHERE field LIKE 'query%' UNION SELECT A,B,C FROM table WHERE field LIKE '%query' UNION SELECT A,B,C FROM table WHERE field LIKE '%query%'…


How to enable Full-text Indexing in SQL Server 2005 Express?

I am trying to enable Full-text indexing in SQL Server 2005 Express. I am running this on my laptop with Vista Ultimate. I understand that the standard version of SQL Server Express does not have ful…


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…



javascript - Wrapping lists into columns

I'm using ColdFusion to populate a template that includes HTML unordered lists(<ul> s). Most of these aren't that long, but a few have ridiculously long lengths and could really stand to be in 2-3 col…




multiple column how with rows table sql select data two