Home > Database Management

Database Management

Database Management forum discussing non-database specific SQL. Structured Query Language was designed to be a robust and standardized language for manipulating relational databases.
Ask Question About Database Management
Dbms free ebook navathe
HI ! can anyone plz tell me the link from where i can download the free ebook in dbms by navathe.. plz help me ,,, need it urgentlyyyy
answer(2)  view(948)  status(wait for best answer)
navathe solutions manual ?
where can navathe solution manual found
answer(0)  view(43)  status(wait for best answer)
MS Access and LIKE Operator
Please .. I've been at this for 5 hours. No joke. I'm using Perl and DBI to operate an MS Access databse. All I'm trying to do is apply the damned LIKE operator to get some records and nothing is working at all. I want to pull results fro...
answer(6)  view(423)  status(wait for best answer)
Desc Table function on SQLSERVER 2000?
Is there a build in function or a way by comand line (select statement) to list all of the columns in a table in SQLSERVER??
answer(2)  view(184)  status(wait for best answer)
web page on a cd??
I have been asked by a client to create a web site on a cd. that is not a problem, I dont hink, but the question is, when I make the pages on the cd, is there any way to have the home page automatically open when the cd is opened??? Will ...
answer(6)  view(480)  status(wait for best answer)
Admin: Wrong forum description
I find that the forum description for this forum isn't perfect: "This is for general questions about databases, including non-database specific SQL, or databases that don't currently have a forum." First of all, all the other ...
answer(1)  view(806)  status(wait for best answer)
Calculating sales ranking
I was wondering if anyone has some ideas on this. Based on a typical products/orders model I need to figure out the sales rank for a given product. Now, I can't imagine a query that can achieve this (this is to be realized on Oracle), so th...
answer(2)  view(790)  status(wait for best answer)
Forum info
This forum was added in response to comments made in a thread in the Lounge forum here: http://forums.devshed.com/showthrea...1181&forumid=26 Hope you guys find it to be useful.
answer(7)  view(308)  status(wait for best answer)
Oracle SELECT INTO OUTFILE problem
Hello, I am using Oracle and trying to output the returned query data to a TAB Delimited file. I tried using "SELECT columns FROM tables INTO OUTFILE 'dir/filename.txt' FIELDS TERMINATED BY '\t' WHERE conditions" But Oracle...
answer(1)  view(732)  status(wait for best answer)
Sybase and MySQL together
Hi, Does anyone have any idea whether or not Sybase databases can be run side by side with MySQL? The Platform is Win2000Server with IS? Thanks!
answer(1)  view(802)  status(wait for best answer)
Want to convert Oracle SQL to MySql SQL
Hi there, I've created a web application. I used windows 2000, Oracle, JSP & servlets to develop the application. But the real server where I want to deploy this application is a linux based machine with MySql database. I tried to de...
answer(4)  view(887)  status(wait for best answer)
Database Driver so ASP can read it
I am trying to access the database via java using asp.. basically the java part accessing the database rather than asp but when I get the the function that accesses the database i get a Classnotfound exception on the class.forname("...
answer(1)  view(259)  status(wait for best answer)
Need info on DNS-less Access connection
I am trying to get some info on using a DSN-less connection for MS Access database. Anybody have some examples/ website suggestion. Thanks.
answer(1)  view(594)  status(wait for best answer)
Try this from a past degree exam paper....!
Hi, a work collegue gave me this to try from a final year degree exam paper as a challenge. If you think you can get your head round it go for it....Its a hard one. Here goes: Write a query that lists the names of those suppliers who h...
answer(2)  view(772)  status(wait for best answer)
Can I run MySQL/Apache/PHP/Perl from CD ROM?
I was wondering whether I can run Can I run MySQL/Apache/PHP/Perl from CD ROM? from CD ROM? I need to give a presentation and don't want to carry my hdd along with me. Is there a way Except hosting the files on net to display the php scrip...
answer(10)  view(76)  status(wait for best answer)
Books on database design
I was wondering if there a few good books on database design out there, or even just some good sites that discuss database design. Chris
answer(3)  view(294)  status(wait for best answer)
What is ODBC?
If I sound confused I am. A friend of mine told me I can create a Access file and then upload it to my server, use an ODBC connection to work with it. We where discussing this in the light of using this method instead of using a text file w...
answer(7)  view(811)  status(wait for best answer)
Database re-construction: Help with elementary concepts.
Hi, I'm new to the forum, MySql and PHP. I have a database setup where a user sends his/her info in a form that is mailed to me and I use another form to copy and paste that information into the database making it viewable to the world. ...
answer(1)  view(963)  status(wait for best answer)
combining many rows into one
Please help me figure out a solution to this problem. I have a table in Microsoft Access that tracks the amount of money received from various companies. In some cases there is more than one amount received from the same company. Here is...
answer(1)  view(562)  status(wait for best answer)
Comparing Files Locally & Sitewide ??
Is there a tool out there similar to cuteftp's compare ? Instead of comparing one directory, I need to compare files from my server to my local drive *site wide* throughout many directories, is this possible ??? -Dreidle
answer(4)  view(565)  status(wait for best answer)
MS Access doesn't export numbers properly
I have a MS Access database, and am exporting it to a txt file for import to MySQl. One of the number column with auto decimal place holds numbers with 3dp. When I export it, the preview window shows them as 3dp as well, but the actual ...
answer(0)  view(245)  status(wait for best answer)
More Food for Thought: database vs filesystem?
See comments about Microsofts plans to incorporate SQL server into Office, so that all user data is stored in a database, instead of files and directories. (yes, some of the comments are mine) I think it's time GUI developers thought abo...
answer(13)  view(108)  status(wait for best answer)
DBX - SQL queried XML DBMS in PHP
Hi, and though this might seem like self propaganda, I really think people might be interested in this: A friend of mine and I have come up with a PHP script that we call DBX, and it is a small scale Database engine. What's cool about...
answer(0)  view(806)  status(wait for best answer)
Database normalisation challenge.... Please help!??!?!?!
Hi, I am struggling with my final year project and need some help on my database structure.... Please can someone help!?!?! I am trying to build a web portal using PHP and MySQL and have sucessfully built and integrated the pages that...
answer(2)  view(676)  status(wait for best answer)
Easiest way to make database searchable?
Anyone have an idea how I can add a search function to a website that would search an MS Access 2000 database and display the results in HTML? I don't want to use MySQL and PHP because I know next to nothing about scripting. What I do h...
answer(1)  view(175)  status(wait for best answer)
the best way of mass mailing on a NT box
i'd like to discuss about the best way of mass mailing on a NT box. Last month i had to code a "monthly news" module for a community site. And we were going to send +50K mails per at oncemonth with that module. I found out t...
answer(3)  view(719)  status(wait for best answer)
merging records
I am trying to combine 2+ records into 1, in the same table with the same id_# but different data in different columns. Does anyone know how to write a query to do that? Any help is greatly appreciated.
answer(6)  view(234)  status(wait for best answer)
Am I in the right place? (Access97/VB)
I am updating an Access97 database for a funeral directors. They have a new entry page to book in a new funeral appointment. On this page, they currently enter the date/time and the vehicle to be used. What they would like now is a ...
answer(0)  view(59)  status(wait for best answer)
Some database questions from a nOOb
I was wondering if anyone knew of any opensource projects similar to NOLA? Trying to do a few things here. 1: learn MySQL and Postgres. 2: Learn PHP 3: Actually build a stable database that works the way I need it. I am having a har...
answer(3)  view(337)  status(wait for best answer)
Replace IDs with corresponding names
I have a small tiny problem that I was hoping someone could help me with. Its Oracle... v8 I have a list of employees. Each employee belong to one workgroup, and each workgroup belong to one department. Each workgroup has got a workgrou...
answer(3)  view(851)  status(wait for best answer)
 
Home - About Infoqu - Contact - Privacy Statement - Link to Infoqu - Bookmark Infoqu

Copyright 2007-2010 by Infoqu. All rights reserved