im consolidating 3 existing databases into one database, with the same
structure, but i have to rediesign the consolidated database.the database
is about civil projects every project has its contractor and design
constructor, with many documents-forms- transmitted between ...

lets have two procedures:
create procedure one
@parentId int
as

Dear DB Professional,
DBNest would like to forward you an opportunity in Middle East
Reference: www.dbnest.com :"Oracle DBA"
Postion: Oracle DBA

Is anybody know in which year was implement soma database on mobile devices PDA???

I would like to save sentences of a text as elements of database. 255
characters (available in type char) should be not enough. And I have
decided to use either type text or tinytext or mediumtext or longtext.
However I do not know how many symbols I can use in each of these types

want to find all records that are NOT in another table.  All the joins
I know return where a record exists.
Ex. I have two tables.  Each have an Item field. I want an sql
statement that will tell me what records in table A are NOT in table B

Michael J. Hernandez's 'Database Design for Mere Mortals', distinguishes
between operational and analytical databases but has very little to say
on the subject of analytical databases, except that they are used to
store and analyse historical data.  I am designing a database to ...

I would like to get the primary key in this statement where I determine
if there are duplicate entries in my table:
SELECT column1, column2
FROM myTable

I have a table with two columns (name, age). Column which should
contain age is now empty (column with names is not). And now I would
like to specify age. For example if name=Bill age should be 23. How I
can make it in MySQL? In many manuals which can be found in Internet

Hi, I am trying to model a relationship between sessions and users but
I don't know how to do it.
It is in a web application. Each user has a login (username,
password). I use each session to store some session-related data.

    media4sale.com offers innovative and quality media, CD/DVD packaging and
    other computer accessories at the best prices. We pride ourselves in
    service, quality and commitment and are certain that our standards will
    exceed expectations.

I have a need to replicate data across heterogenious data sources.
Fortunately within our enterprise each of our replication needs are
uni-directional, i.e., one master.
This is not a data warehouse project so ETL/BI is not required.  I'm

Hello comp.databases
I hope this is the right place to post this question.  If not please
help me find the right place.
I need to create a login system for our site.  What I've found on the

Is it possible to import to Maximo from MS Access 2002 database?

I need to do this but can't figure out the correct syntax... any ideas?
(yes, I know this is wrong, but it's just pseudocode so you get the
idea):
CREATE PROCEDURE foo @Param1 Integer AS