[thelist] SQL Challenge Question

Raditha Dissanayake jabber at raditha.com
Tue Oct 28 07:33:38 CST 2003

Wow, Nice way to bring down your database :-) to do this efficiently you 
need to have an index on each column.  And with that kind of indexing 
your inserts are going to take an eternity, not to mention the disk 
space usage. i know hard disks are pretty cheap nowadays but stil.

Rob Smith wrote:

>I've got an SQL Challenge for you.
>	Given: Two nearly Identical Rows
>	Problem: Isolate the columns where the data
>		   is not the same.
>	Solution: ?
>Can this be done? If so, how?
>Rob Smith

Raditha Dissanayake.
http://www.radinks.com/sftp/          |  http://www.raditha/megaupload/
Lean and mean Secure FTP applet with  |  Mega Upload - PHP file uploader
Graphical User Inteface. Just 150 KB  |  with progress bar.

More information about the thelist mailing list