My problem is one of application design.
I have some objects in my application which map to tables in database.
I used C# and mssql but that's not important.
The database is needed only for storing the results/objects at the end

I am a newly indoctrinated SQL Server 2005 user. So, forgive me if this
question is amatuer.
I am trying to create a stored proc that will read in a list of values
from one table (Possibly using a cte?) then iterate through each record

I have to deal with several dBASE-Files. Does anyone know a program that
provides an SQL interface to dBASE databases without converting or
im-/exporting, quasi a native SQL interface?
I'm using Windows as OS.

The book "SQL Queries for Mere Mortals" says to prepend the table name
to all of your columns.
Other books might say prepend the table name to the primary key column,
e.g., student_id

I have two tables like these: (this is an example, the actual tables
have diffferent fields and meanings)
TABLE1
id

we have a group of developers which have created and asked us (DBAs) to
create many objects in the databases including tables / stored
procedures / functions / etc.
since our company is growing, however we have an increasing amount of

 I've been mulling over the possibility of writing a universal DB
command line interface program.  The finished product would function in
the mode of Oracle's SQL*Plus or PostgreSQL's psql.  The utility of
this program would lie in its ability to make multiple simultaneous

I need to put together teaching materials for a certain subject on
which I am an expert. I'd like an interface similar to video professor,
where i can present my materials, videos, text etc. and users will read
and watch each lesson. Is there software like this available or do I

Hello all. I'm fairly new to Universe and am still learning some basic
commands. Can someone please tell me how I can do a search for certain
records containing a certain title? For example, the table is called
ALERTS and a field in that table is called ALERT.SOURCE. How can I find

I'm helping a friend to build a system to handle advertisments from
local dealers in different regions/cities. In this system, an
advertisment belongs to a region and is connected to one or more
categories (in this context called searchwords).

In a fabulous book -- "Practical Issues in Database Management" -- the
fabulous author, Pascal Fabian, lists three reasons for choosing one
candidate PK over another: familiarity, stability, and simplicity. Just
started skimming through the book.

What do you feel on the comparison between these 2? Any outline on the
pro's & con's?
Nowadays, we have free versions of proprietary databases coming up like
Oracle Express Edition, MS SQL Server Express & the like. And also we

I've decided I need to first document business rules for a project I'm
working so I can design and build a more robust and hopefully
extensible and elegant database.
As yet there are no documented rules to constrain how we conduct our

I am developing a free relational databases watermarking called watermill
(see http://watermill.sourceforge.net) and I am willing to test its
scalability against huge datasets (i.e. millions of tuples). The problem is
that I cannot find sufficiently  large datasets freely available ...

In mysql 5.1, you can this:
select a.*, b.title as btitle from tablename a inner join tablename b
on a.bid = b.id;
but what I want to do is make a prefix name for every column that comes