7,494 Archived Topics
Remove Filter  | |
| | Hi all, I would really appreciate some feedback on my first database design which is depicted in a UML diagram attached. Does it make sense to you? Is it clear enough? Can you spot any immediate problems with it? I'll very grateful for any comments on the representation as such, … Databases database-design |
| | Hello all, I am designing a database and, while I have used simple databases before, I am by no means an expert on relational dB design and so am seeking advice and help. The database functionality I need is as follows: A third normal database in the structure represented by … Databases database-design  |
| | Hi, In my Insert SP, I have 5 local variables: @MemberID int, @VideoID int, @Total money, @DateRented datetime, @DateDue datetime insert into RentalRecord values (@MemberID,@VideoID,@Total,GETDATE(), DATEADD(dd,5,GETDATE())) When I try to execute the SP, I get this error: Procedure or function 'sp_AddRentalRecord' expects parameter '@DateRented', which was not supplied. Please advise. … Databases mssql |
| | Hi Everyone I have been given the task of designing a database for a volutery organsiation and i have been give the following information as basis to design the database.The following information below is example of a paper record •Volunteer details Volunteer ID Name Telephone Address Services provided by volunteer … Databases database-design |
| | Hi Guys I need a hand from a kind SQL*Plus guru to create Oracle abstract data types and collections using SQL*Plus I. Using Oracle’s SQLPlus create Abstract Data Type definitions for the Client and Child member entities called Client_Type and Child_Type respectively. Attributes for Client_Type include client number, name, address, … |
| | I have a database here that I'm re-building to make it more up to date for my customer. They need a Quote table, form, report, etc. Their quote numbers are generated as "2008-000" 2008 being for the year, and 000 goes as the automated number, for each individual quote. This … Databases microsoft-access |
 | |
| | is it possible to convert system made from php with a database of mysql to ms sql database..? how? thaks Databases mssql |
| | how are you every one?? I am student and i just started to study SQL,and now i will start studyabout Oracal . so i want ur advice to be a good student. Databases oracle  |
| | First off, I'm not really a DBA... I'm learning as I go. The office I work in has a lot of problems when it comes to the integrity and reliability of data stored in our Oracle database. One of the little things I'm wanting to resolve is the duplication of … Databases oracle  |
| | Hi Everyone! I have to make a forum with MS SQL, and, as I'm Hungarian, we use characters, like áéíőúű, etc. Now, if I insert a text with the letter ő or ű, I get back o and u. How can I solve this problem? The users write posts in … |
| | Hi All I am writting an stored procedure to get the recently inserted records primary key as follows: [CODE]ALTER PROCEDURE [DBO].[AddEditUserMsgDetails] ( @iJobID [INT]=NULL, @iUserID [INT]=NULL, @vFromName [VARCHAR](50)=NULL, @vFromAddress [VARCHAR](50)=NULL, @vSubject [VARCHAR](50)=NULL, @iListID [INT]=NULL, @vActualText [VARCHAR](100)=NULL ) AS BEGIN /* Logic Comments: INSERTING OR UPDATING INTO THE TABLE ezlMailJobs EXEC … Databases mssql |
| | Hello to all at daniweb.com. I'm really hoping someone here can help me out. I need to complete a final year project at uni to graduate, i have taken database design and administration last year as a module which covers microsoft enteprise manager, creating tables, relationships, stored prcedures and triggers … Databases database-design oracle |
| | Hi I'am doing an online cinema ticket reservation system and i have face a problem with the database design i have these entities: Movie, Branch, Hall, Seat, Admin and customer there is a relationship between the admin and all other entities except the customer which is the admin can add … Databases database-design |
| | Hello ALL, I did the following query. the EXPLAIN result showed 'NULL' in the 'key' colume, meaning that NONE of indexes have been used. However, indexes have been created on Name fields for both tb1 and tb2. I wonder why MySQL does not use the indexes to speed up the … Databases mysql |
| | Hello all, I work for a S/w MNC as an system eng support but I wanted to move into database. I am new to databse. can anyone suggest me how to start with this. It's a new field for me but I want to make my career in this. Do … |
| | Hi everyone. I'm printing a list of articles from my database. Some articles are set as 'sponsored', meaning they appear at the top of the list. Articles also have a 'type' field - if it's set to 0 then there is no specific type, otherwise the value corresponds to a … Databases mssql |
| | Hi Everyone, I would need your help. I have a project that I need to insert multiple records into my table. Here is more detail. I design a purchase order table with 3 columns (a, b, c): a: is primary key with identity (1,1) primary key b: is defined integer … Databases mssql |
| | what is the Major difference between Oracle,Sql Server,Mysql?WHat can do in ORACLE,SQl SERVER,MY SQL?what can't do in ORACLE,SQl SERVER,MY SQL? it is my big Doubt in DB. |
| | Hello Everyone! I'm new to MS SQL, so this may be a dumb error, but anyway, I can't figure it out. I'd like to connect to an SQL server on the internet, I've a valid username and password, but it can't find the server. So, I've tried the following connectionstring: … Databases mssql |
| | hi all!... i have a small doubt... incase i have a database field for ID and i want my id to be of 5 digit field length... and append with zeros incase there are less than 5 digits... example if the number is 34 it should become 00034 please help!.. … Databases |
 | Hi All, I am having problems trying to write unicode characters to a version 10 Oracle database, using C++ and OLE DB (the same code works with MS SQL). If I insert a unicode string directly from PL SQL it works, otherwise I get nonsense when trying from my code. … Databases client-server oracle |
| | i have created a database and populated it with information but i have to run queries on it without using a query builder and am quite rusty on SQL. Below are the tables for the database! Staff : Man no, SName,LName, Address, Tel Mobile. Students: Driver No, Group, Exp Date, … Databases sql |
| | I need to draw a use case diagram for the following: [LIST=1] [LIST] [/LIST] [/LIST]Each member carries a membership card, which is date stamped every time they attend a training session. Their attendance is also recorded in an attendance ledger. Members pay a small fee for attending any session. [LIST=] … Databases session |
| | Hi guys, If there is this scenario where the part must be supplied at least two or more suppliers, how should i represent it in my er model? supplier 2..* supplies 0..* parts Is this the correct way of doing? I'm using uml notation for my er model. Databases |
| | hi what is difference between NOT EXISTS and NOT IN and also EXISTS and IN at subquery thanks Databases oracle |
| | I've got a multi union sql statement however union distinct doesn't work the way I want it to because I just use distinct on 1 column only (link_id). I've several ideas from the internet but I just can't get it to work. Below is the statement. [code] SELECT TOP (500) … Databases mssql |
| | i am working on a home project for basically multiple members to share payments, or for one member to pay and the other members pay them back the concept is sort of like if you have a roommate and you pay all the bills, then he would pay half and … Databases |
| | i'm using vb.net 2005 express + mysql connector to connect to mysql database. i want to save image into mysql database. so i've created a table with img field as longblob. to save the image, first i convert it into byte() and then insert into the table. the problem is … |
| | Hi @ all: I've been looking for an ODBC-Driver for Filemaker. I've searched the web for hours, but i always found Trials of ODBC-Drivers, and that Trials were only for MAC OS. In an other forum, people where talking about a DLL, called "fmfmp50.dll", which should be an ODBC-Driver, but … Databases microsoft-access |
| | hai this is how my project databse luks like different types of industries,with each company having many phonenumbers and email ids..ll industry will have a separate serial numbers but the point to be noticed is that for all industry the table fields are one and the same...nothing differs... wht should … Databases |
| | I have uploaded a case which i have to draw the ER diagrams for a database. Can anyone help me please! i m desperate :( Databases |
| | We are trying to implement MySQL clustering on our E-commerce database, but presently the tables are MyISAM based and some of the tables have full text search index on. In the wake of Clustering environment, one of the requirements is moving to InnoDB. However, that would pose the problem of … |
| | Hi guys I am building a website which allows people to advertise their property online for free. I allow people to upload up to 5 images to my database. I store the name of the file in the database and the image itself is stored elsewhere on the server. I … Databases mysql |
| | New to triggers and SQL programming but I'm trying to figure it out by looking at code examples. I have a table, called child. My program inserts a new child into the child table and stores the parentid as a FK. What I need to do is when a new … Databases mssql |
 | My company has been using an Access 2003 database for a couple years now and the person who previously worked on it just left, the problem is he never gave me the password to unlock the Visual Basic editor window, and I can't seem to contact him. Does anybody know … Databases microsoft-access visual-basic |
| | How do I get [B]ONLY[/B] data type and name of all the columns available in given table_name Databases mssql |
| | Hi, I'm having trouble building the correct syntax select statement for a system to handle support tickets. The table "tickets" has the following columns: id (int) inserted (smalldatetime) ticket_id (nvarchar) owner (nvarchar) subject( nvarchar) category (nvarchar) message( nvarchar) status (nvarchar) The id is unique for each record but the ticket_id … Databases mssql |
| | [I]In this example I'm using the AdventureWorks database in MS SQL Server 2005[/I] I was wondering what other people thought about Schemas vs. Roles when it comes to security access. If you have an employee who just started working for Human Resources and needed access to all the database objects … Databases mssql |
| | Hi, I have a derived attribute in my table and I'm sorting the table in the descending order of this attribute. My query should retrieve all the tuples which have the maximum value for this derived attribute. If I use SELECT TOP 1, I'm only getting one of the required … Databases mssql |
 | Ok, so I'm learning about procedures and functions in Oracle and I'm stuck here with my procedure. I have the function part down pretty good, but the whole returning variables with procedures through OUT mode is confusing me. My task is this: "Write a procedure that accepts a zipcode & … Databases oracle |
| | Hi I have create database by MSaccess in the my computer and I need publish on the Internet to use direct from website. the database contain tables, queries and forms that is as application. I want open the application through the internet. I have background of MSaccess, and what comes … Databases microsoft-access |
| | Heya, what i would like to do in one query is pull out two objs, that are very similar from the same table "ol_obj_data" These two objs are "ratings" and "reviews" they are not linked except for a USER_ID of who submitted them. But they relate to our business data. … Databases mssql |
| | I have two databases and want to combine them. I tried sharing the tables but could not make that work. I tried importing the fields into the master table and that did not work (could not find a copy button). So I laboriously typed in the fields (copied them to … Databases microsoft-access |
| | |
| | hi i am creating stored procedure using cursors, i am using two cursors in my procedure, i takes the two fields in one table that fields are stored first cursor, and second table fields are stored in second cursor, and i check the condition for first table one field is … |
| | Hi, Is a stored procedure faster or a normal inline query in a web application? I use mysql but i guess answer must be same for all databases. Maybe not! Also, how do i test speed of the query in php page and in mysql client application? Thanks Databases mysql |
| | Hi all! I'm trying to write a "last login" message in my login script. The plan is to store dates in the database with UTC_TIMESTAMP and then show them back to the user with CONVERT_TZ, using each user's specified timezone (they have set that on registration). However here lies the … Databases mysql |
| | Hi everybody. I have a clothes and shoes Template with for example created buttons : "numericstepper" and "size" for shoes. I used "-visible=false;" and that is very good. But now, I wish to see these buttons "numericstepper" and "size in the shoes item and never in "bags" or "clothes" items..... … Databases |
| | The two queries are returning two different no of rows.Outer join is not supposed to duplicate the rows in the first table right?How do I correct this. [code=sql]select * from clientcode order by cc_clientcode result:(5627 row(s) affected) select cc.cc_clientcode,cc.cc_rmcode,cc.cc_panno,cc.cc_productname ,c.Client_panno,c.client_userid from clientcode cc LEFT outer join client c on cc.cc_panno=c.client_panno … Databases mssql |
The End.