I would like to know if the following is possible at all: I have a
column in a table that represents some file sizes with different units:
Sizes
------------

Are there any links or articles relating to pagination in databases
for webapplications? The kind you see in search engines like yahoo,
google etc.

I was wondering if I can select a range of value using a LIKE statement.
For example, a column in my table has values: a1, a2, a3 .... a1000 etc.
I want to be able to do something like:
SELECT names FROM table_X WHERE values LIKE 'a[43,300]%';

Does anyone has ideas on converting HDF (hierarchial data format) file to
csv file. Any ideas will be appreciated.
Thanks in advance
Amit

We've been interviewing job candidates today.  I put people in front of
a keyboard, give them a table name and ask them to get info out of that
table in various ways, testing basic SQL skills.  Most of them have been
surprised, and said they've never seen this done before.  Is it ...

HI;
I am looking for a small footprint database, because I do not have a
lot of memory to work with.  The smaller the kernel the better.  I
have coma across PointBAse as a possible canidate.  I was going to use

In my Table following Fileds are there
Credit Debit  date
I want write query to know the Credit Difference ,  debit difference
and overall credit or debit in any 2 dates. Could u anbody help me how

Maybe this is an easy task, but I'm having a really hard time figuring
out how to do this.  I'm a complete newbie to SQL Server.
I have a database dump file from MySQL that's in .sql format.  I'm
trying to figure out how to import that into SQL Server 2000 so that

Dear somebody,
My name is Brian and I'm in the process of modeling a database for an
on-line deli application.  To give you a little background I've
identified four entities in this real-world model.  They are:

I'm doing my Master's Thesis (uni) at the moment, and the work includes a
background study on the most common commercial client database sw / database
server software that are on the market today.
I'm not familiar with the big names on this area, and that's why I would

Please excuse the crude drawing. This is NOT for a computer class, I am
afraid I am too long in the tooth for that. Here is my model and the
associations between the entities.
1) L-----T

I look for universal mechanism, which allows processing large amount
of data at the DBS side. It should fulfill functions like stored
procedures, but have to work both in Oracle and MSSQL. I know that
there is SQLJ, which allows creating stored procedures under DB2,

Have you seen WorkAlerts (www.workalerts.com).
It is nice.  You build rules via point and click and can build custom
emails, pages, etc. of business information (or any other information for
that matter).

I'm looking for MySQL 4.0 ODBC Driver. On www.mysql.com there is only
MySQL 3.51 driver...
Thanks in advance...

I have programmed in Paradox for ten years and in Access for four years and
my websites use mysql and php.
I am thinking it is time to move on with office databases.
What should I be using in an office?