Summary: Hi all, i am desiging a database for a team what i need from this data base keep record of all players, information about every player height , weigh...
Summary: Hey everyone, im taking an SQL class and im working on my first assignment. It seems simple but i keep getting an Error 1062, duplicate entry '1' for ...
Summary: Hello all, My apologies if this has been answered previously, but I could not find anything specific enough to answer my question. I dare say it will ...
Summary: I have two databases. Very simple databases, basic data entry, no links to tables or formulas or anything of the sort. Some employees were entering da...
Summary: You can link the spreadsheets by inputting a simple formula Open both workbooks In the cell you want to show the data from the other spreadsheet type ...
Summary: I find myself very confused regarding database tools and a matter of what does what and what is capable of what. For a personal endeavor of mine, i wi...
Summary: Quick general question... We have the trial version of SQL 2005 installed and now have the full version ready to be installed. I have read that i just...
Summary: I am proficient in most software but have very limited experience with Access. My question is this. Say I have a table for several months containing d...
Summary: Hi, I have a quick question regarding unions in SQL 2005 (using express edition for development at the moment). I am setting up somewhat of a stock ma...
Summary: hi all, have a sql question. i have a table which has a column varchar2(10) which holds employee numbers e.g 'X1234'. I need to update these and...
Summary: I have developed a few reports on SQL Server 2008+VS 2008 and deployed them to the SSRS built in reporting URL (http://servername/reports) During the ...
Summary: Hello, i am interested in learning Microsoft SQL, and possible take a low level cert. I would like to start off as inexpensive as possible, so this we...
Summary: Hi, I am currently working in mainframe.I like to learn SQL.can anyone suggest the best way to get excel in SQL and ORACLE. how the SQL differ from O...
Summary: I'm facing the task of trying to design a check printing system where input by the user will involve the payee (name & address), amount to be paid, a...
Summary: Hi people, I have a question about SQL 2005 stored procedures. I have a stored procedure that determins the current price of a stock item and I want t...
Summary: Hi, I'm designin sort of asset manager software and i'm already stuck with some SQL-querys... :) Tables don't have all the fields yet, because it's ju...
Summary: OK i first want to apoligze for posting a message a couple of months ago about the same issue. It's just that i have no idea what i am doing but i wan...
Summary: I'm rusty with my SQL, but couldn't you do this?INSERT INTO A(primary_key, Name) SELECT sequence.NEXTVAL, name FROM SELECT DISTINCT name FROM B; ...
Summary: Hi all, I'm new to all of this, so be patient. I'll explain as much as I can. I bought a program that is a front-end to a SQL Express database. Ever...
Summary: What do you have? Excell is a bad idea. There's Access, if you already have it. However, why do you call this a "complex" database? The attributes you...
Summary: Hey all. I have a quick question on my sql, im a bit new to the the commands ect and havin a bit of bother tryin to figure out how to do the following...
Summary: You don't have to have your primary key as number? You can easily set the primary key in table design to any field you choose. Just remember that the ...
Summary: SQL is not a Database: SQL is a tool you can use to manipulate data in a database. Almost all DB products support some type of SQL, some support the...
Summary: Hi everyone. Currently, I'm learning PHP/MySQL by writing a script for a simple blog. I need advice/opinion from anyone experience working with MySQL ...
Summary: Hello, I have been stuck on an SQL statement I have to write for class for extra credit. I have been trying to figure it out for literally hours. If...