Databases Forum

Hi, How to check if BLOB field is NULL or Not in a Table though other data is available in a selected row ? I need to do this in a sql statement. Thanks Sandy

What is the limit on how many records you can have in a table in Oracle? It must have a limit. Also, has anyone ever benchmarked Oracle on sorting records... say 1,000,000 records of a small record size, just 2 or 3 fields? :cheesy:

Hi, Iwould like somebody to help me with this exercise : Consider the following relations: BOOKS (Book#, Primary_author, Topic, Total_stock, $price) BOOKSTORE (Store#, City, State, Zip, Inventory_value) STOCK (Store#, Book#, Qty) Consider a distributed database for a bookstore chain called National Books with 3 sites called EAST, MIDDLE, and WEST. …

hi i am gonna create a student record keeping application. i just wanna how which are the basic information means the table in my database are require to create common database i just wanna know table name and require filed in each table which are common in all student record …

I am studying for college for a very complex exam that includes database administration project management, system analysis and many others. I have some database admin questions that I really need help with. Any help would be appreciated. here they r: 1. You are tasked with monitoring and tuning the …

Hello, I'm new to the forum so please give a hand:) I've been working with php/MySQL for about 6 months, just trying out new stuff and so, but now I feel ready to build a REAL site! I'd like to make one of those community sites where everyone has their …

I need to write a query that pulls out Zip codes by the first three characters, so I started with this: [code] SELECT SUBSTRING(Zip, 1, 3) FROM AvailHomeZips AS tZip [/code] But I would also like to query out the zips by those substrings I pulled out, so that would …

I would like to move my forum database to a new server. However, the MySQL database is approximately 700 megs, and takes a great deal of time to import. Doing a [inlinecode]mysql> source backup.sql[/inlinecode] took well over 12 hours the last time I did it, and that was months ago. …

Hello, I am a newbie coder and I am trying to find a way to create a php mailing list. Ive tried looking around but have only succeeded in becoming more lost and confused. I would like the users to enter their email address into the text box and click …

Hi, I created to data tables to hold information provided through peer reviews in the company that I work for. One table has 5 different levels of quality (unsatisfactory, meets some requirements, meets requirements, exceeds expectations greatly exceeds expectations), and another table that holds the data for each peer review …

There are some things that I am in a dilemna with about general database/table design issues. Each has its pros and cons. What do you think are the best practices? Here are some problems. 1. You have 2 tables (or sets of tables) that are exactly/almost exactly the same (in …

+----------+---------------------+------------+--------------------+ |wage_id | full_name | wage | date_added | +----------+---------------------+------------+--------------------+ | 1 | Unknown | 123 | 2001-12-22 | +----------+---------------------+------------+--------------------+ | 2 | Unknown2 | 321 | 2007-06-17 | +----------+---------------------+------------+--------------------+ how to count sum pf values in wage column? 123+321= 444 <---- that way :)

Hiz people ....after a day i m having pracitcal exma....n they have said me to make a database....so i decided to make student database of my school.....very simple so that sir wont ask me hard questions....so plz i think i donno some steps in completing my database....can anyone help.... for …

hi! i have just designed a new database and i was wondering of any could just quickly check that is passes all the first 3 normal forms. this is an image of it: [URL]http://img233.imageshack.us/img233/4174/untitledqg6.jpg[/URL][URL="http://img233.imageshack.us/img233/4174/untitledqg6.jpg"][/URL][URL="http://img233.imageshack.us/my.php?image=untitledqg6.jpg"][/URL] thanks! :)

I am trying to learn about databases and at the moment starting to read general stuff about multidimensional database design. The trouble is, I don't even know the basics about databases, like what is natural key (same as primary key made of single components?) or surrogate key... Could anyone explain …

hi ppl,i have a question.I have column which is a primary key.i have inserted a value also to it.Now again if i insert the same value it shouls not give a error.but instead continue.So how to go about it.like vb onerror is there any way that we can write the …

I am looking for a set of buttons (CODE) for making a NAV set for php and mysql, I need next prev top bottom along with edit add delete reset, any one know of a good starting place to look at least? I would like for it to be working …

I need some advice from the pro's :) I am building an application that has data from several places. The structure is all the same but the data is specific to a user. 1 such a feed can consist of 50,000 rows but on average it's more between 500-2000 rows. …

Hi, I'm creating a customer database in MS ACCESS with the following 3 tables: Customer (with unique customer_id) Products (with unique product_id) Customer_Order(contains both customer_id and product_id). I want to be able to use a form to enter new information into both the customer table and the customer_order table. The …

I'm in need of some help with 3 tables I have with MSSQL. Is there a way to use a single database query to get the results I'm looking for? (See the bottom for an ideal returned recordset.) Thanks! TABLE: APPLICATION APP_ID APP_NM GRP_ID -------------------------------------- 1 Script 1 1 2 …

I am supposed to create a hotel reservation system that allows you to make a reservation either with a hotel package or without and calculate billing. However I am at lost for where to begin. I have made a couple of sorry attempts but I am having problems identifyind the …

Hi, I wish I could solve this on my own but I tried searching and googling but nothing doing. Althought worse comes to worse, I can use Perl to do what I want, but I would prefer having a SQL syntax that can handle it. Problem: 3 columns: username, daily …

i would like to query a date which only showing work week and year... i try in FORMAT([MYDATE], 'WW YYYY', 1, 2)... it work but when goes to 31/12/2006 it showing "01 2006"... but suppose it should show "01 2007" how can i overcome this?

I've about given up on my previous problem. I [I]was[/I] beginning to think it'll be easier to do simply by dropping the user, then recreating it with the appropriate privileges next time around. Only, when I tried (as the superuser, no less) to drop the problem user, I got the …

I really need some help here and hope there are some Access database whizzes out there...and i know...there are.... my friend and I are doing a database project for a health care service... and we are trying to use the expression builder to perform calculations But for our fields, we …

I am trying to maintain a MySQL db which is required for business usage. I recently ran into a problem where one of our programs would blow up with an SQL error; taking a look at the error message, the program description, and the database in question reveals that the …

LibraryDB is a database system that keeps track of information concerning the books and their circulation in an imaginary library. [B]Disclaimer[/B]: The data that populates the database are artificially constructed and by no means correspond to actual real-world data. The schema for the LibraryDB database is given below. [INDENT]borrow([U]transactionID[/U], personID*, …

I want to create a database design where I want to keep all changes made to a database and the user could revert back to earlier versions. Let say there is a table user which has following values initially [code] Userid(Primary Key) FirstName LastUpdated 111 abc 17/05/'07 [/code] Now if …

i have table (id1,id2) 1.row [1,2] 2.row [2,1] 3.row [3,4] 4.row [4,3] 5.row [5,6] 6.row [6,5] i want to get result: 1.row [1,2] 3.row [3,4] 5.row [5,6] or 2.row [2,1] 4.row [4,3] 6.row [6,5] i try anithing, (but not temporarry table), to eliminate cross data, but ... , can you …

Hey all, So here's the deal. I have a list of comments, and each comment gets an automatically generated commentid when it gets added to my mysql table. I just added the functionality to allow users to reply to other ppl's comments ... So I added another field to my …

[B]Description:[/B] The problem is with the SQL. In tbl_comment.comment_mreference, I have made this column varchar(60). It can either contain an integer value, or an alphanumeric value. If it's an integer value, an admin would be logged in and it would have inserted there auto_increment member number into tbl_comment.comment_mreference. If it's …

hi i'm an absolute fresher in DBMS and our teacher gave us an assignment in this there are two questions, we have to draw the UML diagram, find the association, ER diagram,and then to write SQL queries the problem is that i'm little bit confused about the attributes i think …

I'm Using Microsoft Visual Web Developer 2005 Express Edition to design a web site, and it displaying this error " Saver Disabled" any time that i try to run the programm , pls what is d couse of this problem and how can i solve it. am using SQL Server …

Hi, I've run into a situation where I can not see how to write efficient code to perform a check that I need to do. I am running on MSSQL 2005 The check is to compare a varchar passed in to the stored procedure against the words in a table. …

can any body helpme on this point! i have the merge module MSDE n i have to deploy website to another PC i dont want that i install mysql there i want to attach just a fileor dll of database to the project set up . so i will not …

Hey guys, im in deep need of help for mysql. Ive been given a few questions most of them answered although theres 3 which are really bringing me down. I was wondering if u could get some help :D Given this schema borrow([U]transactionID[/U], personID*, borrowdate, duedate, returndate) author([U]authorID[/U], firstname, middlename, …

Hi - I am using Access 2002 (Office XP) I am trying to design a database to use in my business. I have created the following tables: Suppliers, Products, Salespersons, Locations(where the products are sold). I now want to input sales info. I need to input Daily Sales for each …

Asset Table +-------+---------+-----------+ | Date | Asset | Value | +-------+---------+-----------+ |1/1/07 |Building | $1000 | |1/2/01 |Computer | $ 500 | |2/1/07 | Fax | $ 100 | +-------+--------+------------+ Result Table I would Like; +-------+---------------+ | Month | Total Asset | +-------+---------------+ | 1 | $1500 | | 2 …

hi..good day to all i have a table: Question atttributes: SurveyID(FK),QuestionID(PK),QuestionNum,Question and QuestionTypeID if i have a dropdown list specifying the list of QuestionNum in my ASPX page and a delete button besides the list, how can i delete one QuestionNum? after delete, how can i shift the Question Number …

I'm building a large scale application and was wondering the difference between static counts vs dynamic counts. Right now, I'm using dynamic counts. For an example: [code] SELECT *, (SELECT COUNT(1) FROM CarImages WHERE CarImages.carid = Cars.id) as ImageCount, (SELECT COUNT(1) FROM CarBuyers WHERE CarBuyers.carid = Cars.id) as BuyerCount, (SELECT …

Hi, I am currently trying to write some sql that includes a where clause to limit responses but will leave blanks where there is no match. I will include the code so its easier to understand: SELECT DISTINCT teacher.teachername, student.studentname, results.grade FROM teacher INNER JOIN student ON teacher.teachername = student.teachername …

[B][COLOR=Blue]I've used php mambo and oracle 9 to develop a web-based application..I also used separate server for database and the system..but sometime an error occur to the database connection, its display "Could not connect to database" after submit the data..Anyone can help me out to solve this problem? [/COLOR][/B]

Hi I am new to SQL and I am trying to connect to mssql server via vb.net with a code someone else has done. I am not sure why it won't connect. part of the code is below: _DBConnection = New SqlConnection '(ConnectionString) _DBConnection.ConnectionString = "Server=MASTEC;Database=CHH_Cardboard_DA_new;User ID=sa;Password=xxxx;Trusted_Connection=False" _DBConnection.Open() when I …

Hi Everybody, I am a newb in SQL Server 2000. I have a genuine question. Actually what is the use of this sql server, just to store information/datas of small size??? that is: Name: Anish Age:22 Sex: Male in this format?? Maybe this question arises in my mind due to …

I cant call : [111.111.111.1].Database.dbo.fn_test(@test) (Not working !) but i can call : Database.dbo.fn_test(@test) why ? and if no way to call this, can i populate in a function a TABLE variable using a Stored Procedure to do this ? CREATE FUNCTION fn_test(@idcode int,@idoper int) RETURNS TABLE AS RETURN (EXEC …

Hello everyone, I am currently developing an excursion booking system and I am looking for some advice on some matters of database design. At the moment I have the following tables in my system : a table 'user' which holds information such as : login,password,firstname,lastname,address,... Q: is it better design …

hi i don`t know if this is the right forum for this but its an emergency.... does anyone know how to add pictures to MS Access database!! like, to add a column called pictures and under that column we have all the pictures displayed!!! plz HELP

Hi everyone!!! I am absolutely a newbie on database design so please help me out even though questions might seem little stupid [IMG]http://www.dbforums.com/db_images_v3/images/smilies/tongue.gif[/IMG] I m trying to build a database design for an e-learning project; below is the database schema i ve got so far. In the current setup there …

hi.. i've created a table named :Survey [code]CREATE TABLE [dbo].[Survey] ( [CustomerID] [int] NOT NULL , [SurveyID] [int] IDENTITY (1, 1) NOT NULL , [SurveyTitle] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [SurveyDescription] [varchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [DateCreated] AS (getdate()) , [coverletter] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL …

hello, ive been busy trying over and over and over again to write a block of SQL that will perform this task for me but have failed ever time. hopefully someone can point me in the right direction or at least gime a hand cheers. task : to work out …