I'm looking to create a very small cataloguing app for personal use (although I'd open source it if I thought anyone else would use it). I don't want a web app as it seems like overkill to have an application server just for this - plus I like the idea of it being standalone and sticking it on a USB stick. My Criterea: Interface must ...
I will be using LLBLGen to generate a model, however I don't want to solve my design issues by just using whatever built-in inheritance tools it has. I want the model to make sense regardless of the OR/M tool. So, I have several different kinds of entities that can have addresses and each entity can have multiple address (primary, maili...
I have an important Object which have loads of properties. Now few of the properties could have multiple values for example consider, A Channel Object having one or mulitple producers (Now our client think that there could be only few producers like mostly 1 or 2 ). The same issue exist with almost 7 properties. Now i have two solution...
While entering an SQL statement in Oracle SQL Developer, I noticed that I have two choises. I can either "Execute Statement" or "Run Script". A similar choise seems to be available in SQL Maestro as well, altough named "Execute query" and "Execute as script". What exactly is the difference between the two? ...
Hi there, I know there is a way to upload images to the database as image type or varbinary type, however, I searched around the entire week, I am unable to find anything that can help me, so this is really my last resort, if anybody know how to upload images to the database, I am using SQL Server 2005 Express. Thanks ...
I want to learn the answer for different DB engines but in our case; we have some records that are not unique for a column and now we want to make that column unique which forces us to remove duplicate values. We use Oracle 10g. Is this reasonable? Or is this something like goto statement :) ? Should we really delete? What if we had mil...
What is the best commercial database application to create the database structure for a simple local database with one linked table that can create Access, Paradox and dBase files these days? Access, FoxPro, other? Are there any free or inexpensive shareware applications that do not use the BDE to do this? ...
In sybase, using a cursor can one delete the currently referenced row? If so what does the cursor end up referencing? ...
hi all, while trying to figure out how to tag a blog post with a single sql statement here, the following thought crossed my mind: using a relation table tag2post that references tags by id as follows just isn't necessary: tags +-------+-----------+ | tagid | tag | +-------+-----------+ | 1 | news | | 2 | top-story ...
Simple question, would love a solution if there is one! I assume there has to be some keyboard shortcut that will insert a null but Google isn't helping. Thanks in advance! ...
all the procedure help I find is used for select purposes only. can I write a table to truncate several tables? similar to (but this does NOT work) CREATE PROCEDURE clearall() BEGIN truncate tallgrrl.auth; truncate tallgrrl.factory; truncate tallgrrl.farm; truncate tallgrrl.player; truncate tallgrrl.timer; END;...
I'm ashamed to say it, but I have to. I have not worked with ORM's. I'm really considering NHibernate as it seems to be the most mature product for .Net out there (please correct me if I'm wrong). Now, the thing is that we have a big e-commerce/booking system with an SqlServer as the main integration point, containing quite a lot of busi...
Is there a good tool to generate an image of the database schema used in a Rails app? ...
There are available any free instance database over Internet? I mean, there are any Oracle/MySQL/SQLserver database instance (read only is enough) in which I can connect for free (may be registering, of course)? ...
I'm starting up a new web application. It's going to be hosted on a service that charges extra for SQL Server and frankly I don't think the site needs that much of a database. Right now the data model is 5 tables. And I'll be amazed if the largest table ever goes of 10k records. So I'd like to keep the db lightweight. SQLite piqued my ...
I know this isn't a unique issue but I've not had much luck finding examples of how others have addressed this issue. I have an intranet asp.net application I have inherited and am building upon. One particular page is for data entry to submit a claim for approval and we have a form where one record at a time can be entered and it is val...
I'm not fanatic on any database but I wish to see differences between vendors. For instance, I use mostly Oracle and I see that others (MySQL, SQL Server, PostgreSQL, ...) cannot do: Connect by queries. Model queries. Flash back (query, table and database). The same for SQL Server, that others cannot do: Top results. ...
I will be building a set of applications. One of these apps is unattended application (written in VB6) which will write data it receives from various sources to a local database. All the other applications (will be written in VS 2008/c# 3.0) will read this data for mostly reporting reasons. I don't want SQL Server/MySql/Sybase or even...
I'm currently trying to find the best way (in term of usability and performance) when dealing with a situation like fetching records tagged with a specific tag, or category, or something like that. A good way (the way I wanted to do), would be to fetch records with the tag/category slug, so the URL would look like : http://stackoverflo...
in asp.net membership is it possible to change the "userid" type from "uniqueidentifier" to "integer"? and how to do it? ...