2,403 Solved Topics
Remove Filter  | |
| | Hello, I am trying to run my tables in the Sql Workshop using the Sql Commands option in Oracle, and I get this error - "ORA-00922: missing or invalid option". I read that this is somehow related to the NOT NULL option, but I think this is how my table … Databases oracle |
| | yeah i am currently working with raima database and there is no forum i can ask about it. Databases |
| | Hi there, I need to normalize the following structure: Wall covering wood (category) (Product)-----(Models)-----(Prices)(Measurement) Log Cabin-----5/4 x 6------1.85$/square foot-----0.80$/linear foot Log Cabin-----2 x 8--------3.00$/square foot-----1.50$/linear foot Log Cabin-----2 1/2 x 8----6.50$/square foot-----3.50$/linear foot Doors (category) (Product)------(Models)-----(Prices) Panel Door------18"----------85$ Panel Door------24"----------90$ Panel Door------26"----------95$ Panel Door------28"----------100$ Panel Door------30"----------105$ Tables (category) (Product)-------(Models)--------Not peinted-----Waxed----Lacquered … Databases |
| | I'm in the planning stages of an inventory db. The part I can't figure out is how to design the database as far as changing costs go. If I have a cost associated with an item, how do I handle when the cost changes? I know I need to have … Databases database-design microsoft-access |
| | Hi I will explain what I am trying to do: I have used MYPHP admin to create a database where user booking details will be stored in a table called bookings. Now I need to retrieve all the bookings for a specific date. For achieving this I have created two … Databases mysql |
| | I have a table off which I need to parse out the data using certain criteria. The table contains 3 datetime columns called '[B]ReadingTakenOn[/B]', '[B]StartedOn[/B]', and '[B]StoppedOn[/B]' Here's the criteria for selecting the records: The Dates in the 'ReadingTakenOn' column should lie between the Start Date and Stop Dates (both … Databases mssql |
| | Hi am using sql server 2005.. I hav a query like this. [CODE]create PROCEDURE [dbo].[csp_UpdateAutoPart] ( @Code NVARCHAR(6) ,@Quantity INT ,@UnitPrice DECIMAL ) AS BEGIN -- Update the autopart details UPDATE dbo.AutoPart SET dbo.AutoPart.Quantity = @Quantity ,dbo.AutoPart.UnitPrice = @UnitPrice WHERE dbo.AutoPart.Code = @Code end[/CODE] While executing it, almost 32 rows … Databases mssql  |
| | I have mySQL 5.1 installed on a Windows Vista machine. I'm really curious as to where the file lives that holds the databases I created. I'm assuming it's in the mySQL install directory but I just don't know where (C:\Program Files\MySQL Server 5.1\?). Does anyone know? Databases mysql windows-server windows-vista  |
| | Hi friend I have a question of 2 parts I have to insert new entries from a file in a table once every month Is there a way to shcedule an sql query to run once per month, and the second part is how can I only insert some of … |
| | Hi all ! I have been assigned a task to implement an insert query into table a [i] only if [/i] a record doesn't exist in table c. I have been scratching my head for past 2 days and even my best friend [i] google [/i] didn't help me much, … Databases mysql |
| | Hi all Convert(decimal(10,1),(taxid*10)/100) as tax value in taxid is 1. And also im getting .0 result but it should return .1 Plz help me..........why im getting wrong answer. Databases mssql |
| | Hello everyone, I have a fairly simple question about database design. I have a database for county voting equipment. Each county has multiple pieces of voting equipment. I currently have two tables, one with counties and one with voting equipment. Is there any reason to have a relational table between … Databases database-design |
| | OK.. I'm trying to write a query which combines data from two tables. (I'm pretty novice at SQL Queries, so bear with me!) However, I want to exclude duplicate data (based on just one column -- an address field). Basically, I want to only have one result per address. The … Databases mssql |
| | What SQL statement would I need to join the employees/work orders tables to create the desired output (below)? ++++++++++++++++++++ + employees + ++++++++++++++++++++ + id | name + ++++++++++++++++++++ + 1 | Jim Smith + + 2 | Susie Helms + ++++++++++++++++++++ ++++++++++++++++++++++++++++++++++++ + Work Orders + ++++++++++++++++++++++++++++++++++++ + id … Databases mssql |
| | Hi i'm trying to write a simple SQL command to use within PHP. I want to select the whole table, sort by one of the columns, then only display the top 100 rows. Without the[B] WHERE rownum <=10[/B] it works fine. But it displays the whole contents of the table … |
| | i am having an issuse not sure how to approach this i have setup a area that grabs user's / user data by a search now i dont get the same results when i do lower case and uppser case any ideas ? [code]$query = "SELECT * FROM `users` WHERE … Databases mysql |
| | Hello all, I'm currently trying to setup a SQL View that's going to be used to pull info from a table and output it onto a label... Long story short the only piece I need help with is having the SQL view remove leading zeros from one column called "Reference". … |
| | attached is a screenshot of what my table already has for the URL micorosft.com. The column headings are the same as column names. Now, if I do the following statement: [CODE=MYSQL]select * from assign2 where UPPER(keyword1) LIKE '%MICROSOFT%';[/CODE] OR [CODE=MYSQL] select * from assign2 where keyword1 LIKE '%microsoft%'; [/CODE] I … Databases mysql |
| | Hi, I am attempting to write a query to return whether or not a particular items value entered is the lowest value and also unique. For example, if an item as 6 values against it e.g. user_id item_id value 1 101 3 2 101 3 2 101 4 3 101 … Databases mysql |
| | Hi all, In a table column, I have this address value: "Muehlgasse 1 86637 Wertingen GERMANY" I want to get only the GERMANY part on my SELECT code. I've tested this code: [code=sql]SELECT right('Muehlgasse 1 86637 Wertingen GERMANY',7)[/code] It works, but the '7' has to be calculated, because we have … Databases mssql |
 | Good Morning all, I need some help with loading a file into a sybase IQ table with the "LOAD INTO" statement. I have never used it before and I cant seem to get myhead around how I am supposed to implement it in my java app. I have a stateless … Databases oracle |
 | I can handle errors just fine on MySQL, but what about warnings? If I use the following code I still get to see the warning, while that is not what I want: [code=php] if(mysql_connect($host, $user, $pass)) { $conn_server = true; } else { $msg = "Fout bij verbinden naar de … Databases mysql |
| | Hello friends, I want to get the row position a table with respect to the primary key.How can I do that?.Please help me! |
| | I am trying to write a SQL update query for a database column containing an incorrect value. In the JobHistory table (whose primary key = JobID), the ModifiedDt column contains an invalid value, specifically it contains a value from a pickup stop, but I need to use the value for … |
| | I saved a few stored procedures in SQL Server Management Studio. The default Save location, which I accepted, was C:\Documents and Settings\BobLewiston\My Documents\SQL Server Management Studio\Projects. (And yes, each stored procedure was in the form of an .sql file, and I assigned each file name root to be the same … Databases hard-drive mssql sql |
| | Hi everyone, I am creating a student timetable. I have the table done in html and I now need to input the values in the database. I was trying to use something along the lines of [code]if(day = 'Monday' && time = '9') { echo(subject); }[/code] i keep getting an … |
| | Hi Everyone, I am facing one problem in inserting query when i am inserting value of textarea in database. Let me explain whole of this. i am working as a empoyee form in which form when we insert value of all information regarding leave of that employee . In this … Databases mysql |
| | HI there [QUOTE]Exception in thread "main" com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`database/t1`, CONSTRAINT `t1_ibfk_1` FOREIGN KEY (`ID`) REFERENCES `t1` (`ID`))[/QUOTE] The field ID is an auto-increment field and I altered the field to a lower number and now I can't insert any … Databases mysql  |
| | I have a small database, at the present time, built for basic tracking and it has 5 rows ... trackid datetime uid emailaddress orgcodetrack It's populate with 10 records test data from 3 users (uid)... I need to return the total visits from each uid... Here's what I have so … Databases mysql |
| | hey, I am having some trouble with this one. I am doing a student web organiser.The user registers details which goes into userinfo and sem1week1. My three tables are: 1.userinfo: firstname, lastname, e-mail, username, password, coursecode, courseyear. 2.courseinfo: subject, time, day, semester, coursecode, courseyear. 3.sem1week1: username, coursecode, courseyear, day, time, … Databases mysql  |
| | These are just the tables.. STU(SSN [pk], Name, Addr) CLASS(Crs_id[pk,fk], Term[pk], Sect[pk], Fac_id[fk]) COURSE(Crs_id[pk], Description)CLASS_TAKEN (Stu_SSN[pk,fk], Crs_id[pk,fk], FAC(SSN [pk], Name, Dept) Term[pk,fk], Sect[pk,fk], Grade) CORE_CRS(Crs_id[pk,fk]) * term indicates year(4) & semester(1) (i.e, 20091 = Sp 2009) List the names of all faculty members who have taught every course in the … Databases |
| | Hi, I have managed to get a nested query to work partly, but i need to somehow add another nest, which i cannot get to work. To explain more, i wanted to firstly find records that did not exist in another table, to which i used the following [CODE] SELECT … Databases data-structure mssql |
| | Hey Everyone, First post to the forum so go easy on me... So here's the deal... I am writing the php/mysql for a page that updates my database with the values of a member who's membership details have been edited. I am having problems getting the values to update into … Databases mysql |
| | Hi, I'm not sure if this shpould be in PHP or here so apologies if I'm in the wrong place. I'm trying to encrypt a password and insert it into my database along with other data. Everything works when I remove the md5 password encryption. It doesn't work when I … Databases encryption mysql |
| | I have a db, that I feel is efficient, but I have trouble displaying the data the way I want. I can either keep the db and change the display, or I can redesign the db and get the display format I want. I'll try to explain my situation and … Databases web-design |
| | i am trying to mutiply and add 2 dnamic texts on a php form, but i do not seem to get the reply, but i get the following results "sum (4 + 1)" This is the code that i typed in [ICODE](<?php echo $row_standings['w']; ?>+<?php echo $row_standings['d']; ?>[/ICODE] The 4 … Databases mysql |
| | HI I am very pleased to join this forum I am new to SQL programming , I am facing a challenge I need to copy the data from one table in one sql server to the same table in enother SQL Server From Server A table (Employee) To Server B … |
| | Hello all, I'm having the following problem, I have three tables, Person, Income, Outcome Person has the primary key : ID Income has two fields : PersonID [Foreign] and IncomeAmount Outcome has two fields : PersonID [foreign] and OutcomeAmount I need to make a query that gets the summation of … Databases mssql |
| | hi friends I am new to SQL SERVER I am using sql server 2005 enterprise for server and express for client m/cs. Having issue while connecting from client to server. i have read some tutorials on net. while connecting to server from my client machine, i usually get error: 18452. … Databases client-server mssql sql windows-server |
| | hi, i have 3 cols in my db col 1 ( unique identifier ) col2 ( varchar ) col 3 ( integer ) how can i retrive the 3 greatest values from the database on the basis of col 3.. Databases mssql |
| | Hello everyone, I need help. I have two table name: Table 1: resortid resortlocation Table 2 resortid resortname Now I want to get the maximum of resortlocation then getting the name of that specific resort also. I am having a hard time. Can someone please help me? Thanks. Databases mysql |
 | Good Morning Friends, I have a SP that is Supposed to Restore a Database from a Backup. In some Clients this works well but in those particular client its a Problem. The version is SQL 2005. Here is the Code that fails [CODE] set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go … Databases client-server mssql xml |
| | I have an ASP.net 2.0 website with SQL Server as database and C# 2005 as the language. On my webpage I have a calender from which I choose a date and display only the date part in a textbox (readonly) in the format dd/mm/yyyy. But internally SQL Server uses m/d/y … |
| | |
| | Hi, I hope I am in the right place for this... I am looking for some help with a query. Basically, I am using a shopping cart which has option groups and I have created 2 new option groups. I now need to add these option group id's to all … |
| | I am developing ASP.net 2.0 website with SQL Server as database and C# 2005 as the programming language. In one of my tables, I have a filed named RTime of char datatype to store times. The values of this particular field are like 09:00 AM, 09:15 AM, 09:30 AM, ------ … |
| | Hello everybody My problem is that I'm quite new in oracle admin/dev so I need some help pointing me how to limit the number of days of data stored in a table. I have some datasources that come in files periodically. I'd like to limit the days stored for each … Databases oracle |
 | Hello Experts, I am fairly new to MS SQL Server 2005. I am trying to create a table where a column has the restriction of allowing alphas only. I know how to achieve this in Oracle using String functions. But am not able to do so in MSSql. The replace() … |
| | Hi, [code]INSERT INTO money (salary) VALUES ('100,000,000.00')[/code] 100,000,000.00 is stored as 100.00 in decimal (14,2). I don't know what is wrong? Thanks Databases mysql |
| | Hello, thanks in advance to anyone who can help me with this query. What I am trying to do is to retreieve a list of all the users from the table 'users' and count how many posts the user has made. The code below will shows a list of users … Databases mysql |
The End.