Our application currently stores bunch of configuraton & application specific data to files on disk. Configuration data is stored in a single .ini file where as application data is distributed across multiple files. The application has grown now and data manipulation using files is becoming a nightmare. We would like to make a switch to ...
Duplicate Advantages of MS SQL Server 2008 over MS SQL Server 2005? What are the major differences between Sql Server 2005 and Sql Server 2008? How could I convince my organization to invest in Sql Server 2008? For me, one major aspect that I see is that they have a good framework to programmatically generate SSIS packages with the us...
i know some of you are going to say that this isnt the correct way but im on a tight deadline to finish an application and as of now i cant go back and modify the code to store the images in a directory. now that thats cleared the question i had is i inserted an image into the database by typing this. (dont mind the class security ca...
Background: Okay, so I'm looking for what I guess is an object database. However, the (admittedly few) object databases that I've looked at have been simple persistence layers, and not full-blown DBMSs. I don't know if what I'm looking for is even considered an object database, so really any help in pointing me in the right direction wou...
I have one long excel sheet with books details of a library..can i import this data into a .mdf file. ...
Hi, let's go straight to the problems (with Grails 1.1.1, it should work on previous one) I have 2 domains ie: User and Detail like this : Class User { String userName ; ..... // another fields static hasMany = [details:Detail]; } Class Detail{ String detailName ; ... // another fields static belongsTo = [user:Use...
Hello all; I have a database table of my own that I am trying to construct a query for that seems simple enough, but I feel like I am messing up somewhere because the results are not what they should be. I basically have a table that is like the following: Table: Data Columns: Row ID Profile Import ID Field ID...
I have a rather simple PL/SQL query (...) DECODE(upper(Table.Column), 'SOMETHING', '---', TABLE2.COLUMN2) as VALUE (...) How can I apply the WHERE clause using above statement, because when I use something like: WHERE upper(VALUE) like 'SOMETHING' it gives me an empty recordset (and I am absolutely positive that there are records w...
How to import data from a database to Joomla CMS? I have a database with lots of data I want to use in my new website. An ideal solution for me would be a Python/Perl/PHP API that would know how to do Joomla' basic routines: adding/removing a section/category/material/menu/module; changing properties of existing entities ...
There is frequently the need to synchronize data from master tables in one database to clone tables in other databases, often on other servers. For example, consider the case where a backend system manages inventory data and that inventory data ultimately must be pushed to one or more databases that are part of a web site application. T...
Major Edit: I misread the article! The comment was in regards to the finalize method of the the class not the finally block :). Apologies. I was just reading that you should not close or dispose a database connection within a finally block but the article did not explain why. I can not seem to find a clear explanation as to why you w...
I'm trying to build a Hibernate layer for a database schema I have essentially no control over. Simplified, there are two tables. Table parent has two important columns: parent_id, integer, primary key, autoincremented parent_code, string, unique key, generated by a black box somewhere (let's say this is a UUID for sanity's sake) Plu...
has anybody done anything with scripts to parse an incoming e mail to a specific address, strip out the data and insert it into a SQL database? The e mail would be coming in through exchange 2003 server and would be in a known fixed format, ie Name: Firstname Surname ID Number: nnnnnnn etc. etc. Ideally the solution would need to oper...
Hello sql gurus, Is there a way to limit the number of rows in a SQL Server 2000 database, such that older rows are deleted when new ones come in? I have some data that I'd like to keep around for a about thirty days - after that, I don't care whether the data lays around or is deleted - as long as the table doesn't become huge. Any o...
I am working on a barcode application for reading commercial products. I was wondering if anyone knows if there is a database containing commercial barcodes and their associated products that I could purchase? As an example: I would like to be able to scan in the barcode from a candy bar and query a database to retrieve the name of the ...
Can anybody recommend a good book(s)/paper(s)/article(s) on Full Text Search (and maybe indexing in general). I'm pretty anal about having to understand what's happening behind the scenes in my applications, and I'm having trouble understanding why Sphinx and other external FTS's leaves MySQL/MyISAM in the dust. ...
I have 3 tables bl_main (bl_id UNIQUE, bl_area) bl_details (bl_id UNIQUE, name) bl_data(bl_id, month, paper_tons, bottles_tons) bl_id is not unique in the last table. There will be multiple rows of same bl_id. I am trying to retrieve data in the following way bl_id | name | bl_area | sum(paper_tons) | sum (bottles_tons) | paper_to...
I am designing a new laboratory database. I want to store the raw results for all tests together. However, results can either be a single measurement or a raw waveform. (repost see footer) Which case below is ideal (and why)? ... or provide your own ideal option. TEST test_id* (other TEST fields) OPTION 1: Separate single values...
Anyone know of a free/open source OLEDB/ODBC/JDBC driver against DataEase? ...
With regards to SQL and queries, whats the difference between an in-memory table, temp table and a pivot table? ...