7,494 Archived Topics
Remove Filter  | |
| | I am trying to help a friend make a database(and ultimately piece of none commercial software) to determine personality type as part of his thesis. For the formula to work properly a couple of the questions need their values inverted(ie if the person answers 1 the recorded number will have … Databases mssql  |
| | i m using sql 2000 and i have a table with 3 columns ( credit , debit, total) what i want to do is whenever a value is inserted to the credit column it should add that amount to the total column and whenever there is a debit value it …  |
| | Hi, How do I change maximum connection to mysql database and maximim user connection to mysql? Thanks Databases mysql |
| | Iam writing (or trying to write) a simple join query statement in Query Analyzer. As of right now Im getting the error message Ambiguous column name 'categoryID'. My Statement is ; [code=sql]Select categoryID, Max (StockPrice) as maxStockPrice, MIN(StockPrice) as minStockPrice, AVG(StockPrice) as avgStockPrice From Category, InventoryPart Where Category.CategoryID = InventoryPart.CategoryID;[/code] … |
| | Hello. I have searched, and found database tool the [URL="http://www.powerdbtools.com"]PowerDBTools[/URL]. Who knows how can I convert my Access database to SQL 2008 with this tool? Thank you. Databases microsoft-access sql |
 | Hi all I'm having trouble displaying special characters. I have a database that has a number of characters from different languages and I've managed to display almost all of them. But I still have some characters showing up as a question mark inside a diamond. The code I'm using in … Databases mysql |
 | For example, I have the following tables: animal ----------------------- animal_id | animal_name ----------------------- owners ----------------------- owner_id | owner_name ----------------------- owners_animals -------------------- owner_id | animal_id -------------------- I want to find the animals with no owners so I do the query: [CODE]select animal_name from (select * from animals) as a left join … Databases |
 | Hello every one i downloaded [B]"microsoft sql server 2005" [/B]and installed it correctly but i m now confused b'coz i can't find [B]Query Analyser[/B].Can any one help me out of the situation . Databases mssql |
| | Hi, i'm sql newbies, hope someone can help. I'm trying to do a tariff lookup table for my voip service. When a user makes a call, i capture the destination phone number which has the country code prefix (the prefix may have or not have the plus sign). I'm trying … |
| | |
| | Hey, so I have a form and i want to break down the form into 2 sections when inserting into my database. I have made 2 tables to hold my values. this is my SQL statements. [CODE] $sql_insert1 = "INSERT INTO `agent_users` (`user_name`, `password`, `primary_email`, `secondary_email`, `join_date`, `last_accessed`, `activation_code`, `first_name`, … |
| | Hey folks, I am loading the database from the text file using load infile command, what i wish to do is to delete last inserted data not just the last row i.e all the data i have loaded from text tile.I am working on MySQL. Thanks in advance Prankyrules Databases mysql |
| | I need to automatically generate ER diagrams by giving the database schema. If somebody knows a free and open source tool for that, please tell me. Databases open-source |
| | Hi I have a table with two columns (ID,ROW) I need to make the ID COLUMN unique and increase it value by 1 for each row. ----------------------- ID ROW 1 NULL 1 NULL 1 NULL 1 NULL How can I replace the each 1 with sequentially increased value? to be … Databases mssql |
| | i am writing a java problem connecting to mysql database. i don't know why data type decimal or numeric woudn't store any decimal numbers. my java program would output: [code] Type was: DECIMAL [/code] when trying to insert number like 23.50. what data type should i be using? probably not … Databases mysql |
| | userfood table auto_id | userId | date | foodname | perserving | satfat | monofat | polyfat | protein | carb 1 ------ 1234567S --2010/02/01 -- chicken rice- --- 382g ----- 8.7 ----- 9.1 ---- 3.7 ------ 25 ----- 75 2 ------ 1234567S --2010/02/02 -- mee siam----- --- 683g ----- … Databases mysql |
| | I have an Access database (Databas1.mdb) with one table (Tabell1) containing one column only (SomeData). The column is Text and has the primary key assigned to it. Executing the code, i.e. clicking btnAdd gives a synrax error on the INSERT INTO-command when reaching the cmd.ExecuteNonQuery()-statement. [CODE] using System; using System.Collections.Generic; … Databases microsoft-access open-source visual-studio |
| | hi all, i have a database called DB with a table called Menu_reporting that logs when the user selected through calling the server (See below) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ USE [DB] GO /****** Object: Table [dbo].[Menu_Reporting] Script Date: 01/31/2010 17:07:26 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO … Databases mssql web-server |
| | sorry but i am new to my sql, I have just a basic question.. and that is how can i create a database or table on the server! I have learned that we can create database or table by using my sql command line... but the main problem is our … Databases mysql |
| | Hi, What all are the ways to synchronize two SQL databases? If there is a way to do it via query or code, what is that query/code? Please help. Thank you.  |
| | Hi all. Bit of a problem - hope somebody can help. I am trying to return lists sorted alphabetically in my native language - Welsh. The alphabet: a,b,c,ch,d,dd,e,f,ff,g,ng,h,i,j,l,ll,m,n,o,p,ph,r,rh,s,t,th,u,w,y (29 letters) Note that there are 'double characters' - these are considered as single discrete letters. Roman letters (k,q,v,x,z) can be added … Databases mysql |
| | Hi All i am quite new to mssql db and would like to find someone to help me with some errors i keep getting i have uploaded my new db and when i try to open my website i get the following errors [code] <!-- Web.Config Configuration File --> <configuration> … Databases mssql |
| | Hi. I am complete beginner in databases, so please bear with me stupid questions. I am just doing for fun a simple exercise. A faculty have students and each student have different subjects. My question is, how to store the different subjects in the db? I could make up some … Databases mysql |
| | I have a database column defined as int that contains a negative number representing a date in mmddyy format (without the leading zero) so -10209 = 01/02/2009 -122508 = 12/25/2008 How can I convert the data to a datetime so I can compare it to another date in a where … |
 | i have 2 tables: category, location. i create the tables: [CODE]create database tourist; grant all on tourist.* to dbuser; use tourist; create table category(id integer NOT NULL AUTO_INCREMENT,season varchar(20),num_summer integer,num_winter integer,PRIMARY KEY(id)); create table location(code integer NOT NULL AUTO_INCREMENT,town varchar(20),hotel varchar(20),price integer,star integer,media varchar(70),PRIMARY KEY(code)); [/CODE] i want now to … Databases mysql |
| | Hello DB gurus, Does anyone know how to approach the situation where a record's status (in this case "is_in_recording" for example) depends on multiple records in another table? I have a "files" table and it has a boolean "is_in_recording" which if set to TRUE means the file is used in … Databases |
 | |
| | I'm a student in an E-Commerce program and I agreed to do a capstone project in my web design class as a blog site, where I can register users (with an access database) and have them update entries whenever they feel up to it... I'm a competant web developer, but … Databases database-design web-design |
| | i have an access table that contains the following: ID Number, Store Number, Sales Region, Item Number, Item Description, Unit Price, Units Sold and Week ending. One of the queries requires us to find the best selling products by quantity and another by units sold. I'm confused on the formula … Databases microsoft-access |
| | Hi guys, In my application users can search for events that fall with in a particular date range, which works fine. The problem I am having is getting records when I ask for the current months events using the query below. select * From Events Where FromDate >='1/1/2010' And ToDate … |
| | Hello Guys; I’m studying computer science on my third year. we are asked to develop a project based on data warehousing and business intelligence, using java language and postgresql. the main thing that is expected from us, to create fact and dimension tables from existing tables and then fire simple … Databases data-science postgresql |
| | Hi Friends, Can there be a query that will SELECT fields of a table and group a column (say "CustomerID") and show all its rows along with its subtotals and then its Grandtotal in the result returned? For Example, CustID Items Cost ExtraCharges --------------------------------------------------------------------------------------- A1 Cofee 15.00 2.00 A1 Tea … Databases mssql |
| | Hi I have a ASP.Net code below that need to query with MS SQL database. [code] "select SUM(ShopCartItem.Price-OfferedPrice) As Discount from ShopCartItem " & _ "Inner Join Product " & _ "On ShopCartItem.ProductID = Product.ProductID " & _ "Where(ShopCartItem.ShopCartID = @ShopCartID) And ShopCartItem.ProductID != @ProductID" [/code] The MS SQL query … |
| | [CODE]See current output starting at page DROP TABLE EMPLOYEE; DROP TABLE JOB_TITLE; Create Table EMPLOYEE ( EMP_ID int NOT NULL, LAST_NAME varchar(20) NOT NULL, FIRST_NAME varchar(20) NOT NULL, EMP_ADDRESS varchar(25) NOT NULL, EMP_CITY varchar(25) NOT NULL, EMP_STATE char(2) NOT NULL, AREA_CODE int NOT NULL, PHONE_NUM int NOT NULL, HIRE_DATE datetime …  |
| | I am building a database that handles food and nutrition intake. The database i am designing is fairly difficult so i was hopping i could get some help from the community. --------------------The database does the following---------------------- 1. track food intake aka total 'sugar', 'protein', vitamin B12 for all users 2. … Databases database-design web-design |
| | Hey guys, I'd posted earlier about creating a database for a vaccination clinic is a slum. All the responses were really helpful (thank you!) but I'm encountering some further problems. In a table named "Table Children" I have a "Date of Birth field" and and an "Age at the time … Databases microsoft-access |
| | Hello every one I am trying to insert text into oracle 10g, which contains ( ‘ ) single quotes. I know its simple , I have tried google. This is the error I get Warning: ociparse() [function.ociparse]: ORA-01756: quoted string not properly terminated in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\qmon\age.php on line … |
| | what type of indexes exists in Sql Server ?which one is the fastest and why can we only have one of those per table ?  |
| | Hi, I'v only just downloaded MySQL and I'm trying to import a text file but i keep getting an error message: "#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2009-08-24,00:00:00,2009-08-24,00:01:00,1,444,261,0,0,0 00:b0' … Databases mysql |
| | Hi all, Been pulling my hair out on this one. I have a simple query: [CODE]$query = (" SELECT course_code, student_grade, start_date FROM ccdata WHERE student_id = '$local_id' AND start_date= '20091023' ") $result2 = $mysqli->query($query, MYSQLI_STORE_RESULT); //$total_courses_I = $result2->num_rows; while ($obj2 = $result2->fetch_row()) { $course_code = $obj2[0]; $ypos += 5; … |
| | Hi... Have a slight problem with a database I am making... I think I am missing something really obvious! I am creating a database, which will generate invoices for money owed by clubs in a sports league. I want to be able to generate monthly invoices, for each club, which … Databases database-design linked-list |
| | hi, i am using this datetime data type in one of my mssql tables... i just want date & not time........ can any one help me with a patch of code....... thanks in advance Databases mssql |
| | I have two tables but I'm thinking it should be one. one is: [B]Courses [/B] columns are: [B]CourseID, Title, Description, Objectives, Price, Length, Prerequisites[/B] the other is: [B]CourseDetails[/B] columns are: [B]CourseID (where this is checked against the Courses table, must exist in the Courses table), CategoryID, TypeID, SubTypeID, Type[/B] First … Databases mssql |
| | i am new in sql and i would like to ask you if i can make a class in mysql. For example class test { INT AGE; INT YEAR; } CREATE TABLE lol (x test); can i do this? Thank you very much Databases mysql |
| | I wonder how or in what way to autosave a picture (in a form) when an attached digital camera shot a client. Databases  |
| | I would like find out is it advisable for me to have the city and province on a seperate table and then link them to the country table. This is because a city is govern by a mayor where else a province is govern by a governor. [B][U]country [/U][/B] - … Databases |
| | I am trying to calculate the ending inventory cost using weighted average. I have figured out a column for the cost per item (CostperItem), and a column for item on hand(QuantityAvailable). Now I want to multiple those two columns together and get a new column for the result. how can … Databases mssql |
| | CREATE TABLE Item(Item_no varchar(10), Type varchar(10), Size varchar(10), Colour varchar(10), Brand varchar(30), Purchase_Date Date, Price varchar(15), Hiring_rate varchar(10)); What's wrong with this CREATE ＴＡＢＬＥ query? When I try to insert it, it was told invalid identifier. I dunno why. Plz help me. Thank you very much!!! Databases mysql |
 | Hi there Can somebody please give me a link to a tutorial regarding materialised views/snapshots (preferably in Oracle) and perhaps some sample scripts too. Thanks in advance. Databases oracle |
| | Hi, I'm developing a Visual Studio C# application, which is related to a database. It currently uses a database file (SQLite). But I want to connect it to an online database. The idea is: the same copy of database should be on users' computers (in SQLite files) and on a … |
The End.