into (8,472)


SQL Server 2005 implementation of MySQL REPLACE INTO?

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…


Python and MySQL

I can get Python to work with Postgresql but I cannot get it to work with MySQL. The main problem is that on the shared hosting account I have I do not have the ability to install things such as Djan…


Have you ever encountered a query that SQL Server could not execute because it referenced too many tables?

Have you ever seen any of there error messages?-- SQL Server 2000 Could not allocate ancillary table for view or function resolution. The maximum number of tables in a query(256) was exceeded.-…


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"?…


Reading a C/C++ data structure in C# from a byte array

What would be the best way to fill a C# struct from a byte[] array where the data was from a C/C++ struct? The C struct would look something like this(my C is very rusty): typedef OldStuff{CHAR Name[8…


What are the different methods to parse strings in Java?

For parsing player commands, I've most often used the split method to split a string by delimiters and then to then just figure out the rest by a series of ifs or switches. What are some different way…


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…


Locking a SQL Server Database with PHP

I'm wanting extra security for a particular point in my web app. So I want to lock the database(SQL Server 2005). Any suggestions or is this even necessary with SQL Server? Edit on question: The que…



Convert Bytes to Floating Point Numbers in Python

I have a binary file that I have to parse and I'm using Python. Is there a way to take 4 bytes and convert it to a single precision floating point number?…




how from file string multiple insert array with data split