Databases Forum

Hi, I have this question, having two numeric values field1 and field2, i need field3 by default to be the difference between field1 and field , any idea??

Hi , Can we have an sql query to get the max 5 values from a column? Please paste a sample code if its possible. Thanks in advance.

can someone help me identify the syntax error with this code [code] CREATE TABLE IF NOT EXISTS Persons ( id_number VARCHAR(13) NOT NULL , name VARCHAR(45) NOT NULL , name_2 VARCHAR(45) NULL , name_3 VARCHAR(45) NULL , surname VARCHAR(45) NOT NULL , date_created DATE , date_modified DATE , PRIMARY KEY …

hi all could any 1 help me out. im trying to find the biggest id number in a db. the problem is that the "ID" column is saved as "TEXT"(its important to me). the language im using is PHP. 10x! tried to use this but it didnt work $resultt = …

A friend referred me to this forum knowing I've been struggling for quite a while unable to find proper help. She says the people here are excellent and quick to respond. I do hope I am posting this is the correct forum area.:-/ My problem is is that I have …

i want to relate my tables, but i can't find out how to relate the tables. how?

Hi all, i hope anyone of you can help me on the following matter: I have two tables: Recordingid Connection Sequenceno 1233036621 1 3 1233036621 1 4 1233036621 2 8 1233036621 2 9 And the second one: Recordingid Connection Sequenceno Code Cause 1233036621 1 1 21 9 1233036621 1 2 …

hello, i have a table having 4000 (four thousand) records and now i want to delete 3000 of them as i don't need them, these records have primary key as id which is ofcourse unique. can anyone tell me how can i delete these records with one query. if their …

I have a problem with creating this database. I want to create the student record system. I have a table containing Individual information and using of ID as primary key. For registering grades I use another table for grades. But here is the problem. Here we have 6 or more …

Okay, I'm a little confused - this code works perfectly fine in mysql; however, in php it keeps repeating the first person for about 15 rows. Can someone point me to what I'm missing here. [code] $queryUsers = "SELECT user_id, zipcode, gender, housing_status, active, username FROM users WHERE user_id != …

I am using MS-SQL 2005 DB. One of the tables in the DB, that I inherited, has gotten upto 37000 records. And it will go up by another 50k records soon. Does that make too much data for one table? The table has about 25 columns, most of which contain …

Please Help me, I have 2 Table, A dan B. Table A : Sandar | jmlMuat --------------------------- Mirah | 20 Berlian | 10 Table B : Sandar | jmlBongkar ------------------------------- Mirah | 30 Nilam | 15 I want to join that table to get result like this : Sandar | …

Sorry for posting this in this forum, but there is no forum for PostGreSQL. I am currently attempting to optimize a function that uses up to 3 seperate SELECT queries, by using a CASE conditional in my query. Right now my function does an initial query, then if no results …

The title to the thread pretty much describes what I am getting stuck at. I was able to create a procedure successfully, but everytime I try to execute it, I get an error:[QUOTE]The EXECUTE permission was denied on the object 'sp_OACreate', database 'mssqlsystemresource', schema 'sys'.[/QUOTE] Logically speaking, if the DB …

Hi everyone! Im actually doing my final year project which is an ecommerce application for a specific business. there is another student who is working on the MIS part of this business. we have to use the same database. I am using PHP and MySQL and he is using ASP.net …

Hi, I have written a sql script which takes the rows from a table and writes it to a .csv file. The script is as follows:- [CODE] set feedback off; spool output.csv; set heading off; SELECT username||','||profession from users; spool off; [/CODE] This works fine but output.csv contains a blank …

Hii I Have Facing with Order problem i try to query From Table it go like this -> [code=sql]SELECT * FROM Client WHERE (ClientName LIKE 'X%') OR (ClientName LIKE '%[ ]X%')[/code] It mean give me all clients that start Whit X Letter And Included MiddleName If There is And Last …

Hi, I am new to Access 2007. I have two columns in my table, Make and Model. The Make column is a lookup from a Makes table which has different makes of computer (Dell, Toshiba, etc...) in it. I also have a Model column adjacent to it which is set …

Hi, recently i needed to query a table , however i was denied "Select " permissions (because permissions had not yet been exported as the db was). Should my application enable for administrator to grant permissions , if that error occurs OR should permission granting be done through MS SQL …

Hello, I am working on a website using a MySQL database, certain pages contain tables from the database. Also there is an admin where someone can edit (replace) values in the table. Everything is working, but I have one problem. A row in the table is named 'Best Moment' which …

Hey Guys, So I'm working on an ASP page and I am making use some select statement. Now, I need to specify a where clause and make the only condition in there optional, i.e.: [CODE=SQL] SELECT * from table where Upper(name) LIKE "SID" [/CODE] I want to make [CODE=SQL] where …

I'm trying to bind to querys and would like to know most efficient way to do it I have these that both need binding as one SELECT * FROM categories ORDER BY categoryDesc and select count(*) as amount from products where idCategory = "&idCat&" and listhidden = 0" idCat is …

I have this table (Account) containing fields ID and ParentID. ParentID's value is the ID of the parent account for that account. Now, I set up a trigger that on delete of the parent, all children also gets deleted. But the delete only works one level. I mean when I …

Hi all hopefully I can explain my problem correctly, this is my first post on DaniWeb. I'm currently working on a legacy medical research database that uses a Varchar field to store a decimal number, this field can also be used to store text entered by a researcher on the …

How to encrypt and decrypt an existing column ?

Hi everyone, So I need to find out if a date entered is a Sunday. If it is, I gotta do something special with this data. I'm not sure if Datepart will help or how to use it effectively to extract if it's a Sunday or if it's 1st day …

I need help with a query. Looking though the forum and other online resources I can usually figure out what I need, but I'm drawing a blank on this one. I have a clients table which has client info in it, and a receipts table with receipt info. what I …

hello to all, I am using MS SQL 2005. I have 3 tables, COLLAGE, USER, STUDENT I am providing username & password to collage as well as students. I wanted to assign Foreign Key to 'username' in both tables College & Student. i have done, 1. right click on username …

hi all ..how are u? i have a problem and i need ur help plz ...i downloaded Apache2.2 server and php 5.3 and now i'm downloading mysql5.1.37 ...but there is a problem ..when i start the Mysql Server Instance Configuration wizard it tells me to choose between 2 version ..and …

Not quite sure whether this is a question for the server side programming forum or for SQL forum. Nevertheless, here it is: What is the best way to update a record when 2 users of my site happen to edit it simultaneously? For example, assume the following scenario: Let's say …

hello everyone. i'm a newbie to ms sql but i understand the basics of adding tables and linking them. i have two tables tables that i have linked; Department and Employee. The Department table is the main table with a foreign key in the Employee table. now from by basic …

Hey all :) I am currently working on a database and stuck on a question regarding SQL. I know the basics of SQL although this question has me stumped A list is required of dogs that have career winnings better than that of the average dog. List the dog_id, dog …

Good Day All I have SQL 200 and a SQL 2008 in one Machine. At First there was SQL 2000 and i install SQL 2008. Now we have a ilog Application written in C++. am not sure what that developer uses to connect to the SQL. Now the Application can …

The Paradigm I recently was finally given a computer for work, which runs on Windows XP. I had previously been working using my personal Linux laptop, and had developed several MySQL/PHP applications to aid in data entry and SQL reporting, all of which ran on localhost. I use an "include" …

Hi, please I need a query that performs the following: I have a table like this: set_id | rec_id 10 | 1 10 | 25 10 | 32 20 | 61 20 | 90 30 | 77 Now I have suppose rec_id = 61 and rec_id = 90 I need …

I've only written one stored procedure in the past and I'm being tasked again to write another one. The purpose of this SP is to do a bulk insert from a .txt file and then to move the file to an "archive" when it's done with the bulk insert. The …

I am having a problem restoring my clients MSSQL database onto my desktop using Enterprise Manager. Apparently the database itself contains information about where the original database was backed up from & irrespective of what alterations I make in Enterprise Manager the restore fails. Is there some other program I …

How to make a constraint to check if the entered time is in valid form?

I want to create a procedure which takes one input parameter(@name) and list all the fully or partially matching results. I used [code=sql]Select * from Table1 Where Name LIKE @Name[/code] but it didnt work. Can you help plz?

How can I add a check constraint to make sure that a date is equal to Today or within the last year and another check constraint to ensure that dateA is equal to dateB or earlier by a maximum of 3 days ?

Hello all. I want to add the mysql to ODBC sources. Im currently running windows vista, and in the control panel, Data Sources (ODBC) when i try to add a system Dns as source i cant find mysql in the list. Here is a pic(so you dont spam [url]http://dev.mysql.com/doc/refman/5.0/en/connector-odbc-configuration-dsn-windows.html#connector-odbc-configuration-dsn-windows-5-1[/url] or …

So, i'm working on VB.NET application but I'm having problem with one MSSQL query. [CODE]SELECT ISNULL(Sezona.NogSezona, '') FROM Trener LEFT JOIN Licenca ON Trener.BrTrenerskeIskaznice = Licenca.BrTrenerskeIskaznice LEFT JOIN Sezona ON Sezona.IDSezona = Licenca.IDSezona AND Licenca.IDSezona=3[/CODE] This is the code I've been using 'til now, but it's not working as I …

hi guys I want know that whether is it possible that to implement Client - Server architecture by using SQL SERVER 2005 EXPRESS EDITION as a main server and on other client PCs also I have SQL SERVER 2005 EXPRESS EDITION . So can i connect to main server from …

Hello, I have a problem and I hope someone could help me with this. I have a student registration database. The case is that there is courses that student can register in. And when they register there a groups formed for the courses. So there may be 2 groups that …

Hello all. I have a small problem with sql. I have a table that has name and rank. For example the ranks would be getted like : select name,score from scores order by score desc So the first line i would see would be person with rank 1, second line …

Hi expert, I'm facing a problem when i try to update the database, below is my code: Dim conn As New OleDb.OleDbConnection Dim strSQL As OleDb.OleDbCommand Dim ra As Integer Dim num conn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;" & _ "Data Source=C:\employee.mdb" conn.Open() strSQL = New OleDb.OleDbCommand("Update [emp] Set e_name = '" & …

I am working with a third party program that sends data and files to a web based repository for our customers. I have rewritten the ASP side of things and cleaned that up but we have run across a problem. The internal (3rd party) software when sending files to the …

Hi Im trying to execute a the following query, but its throwing me an error [code]select apex_item.checkbox(1,"EQUIPMENT_ID") Tick, ef.equipment_type as "Device Type", e.equipment_name as "Device Name", ef.equipment_id, ef.Customer_Name as "Customer Name", ef.Site_Name as "Site Name", ef.Managed_Ip as "IP Address", dst.discovery_state_name as "Discover State", d.Error_Code as "Error Code" , d.Last_Discovery_Time as …

I am using the SQL 2005 Express edition for SQL server. The database resides on another server and I connect to it from my machine through the object explorer. I have created a trigger to run certain queries and updates, but can't seem to find the trigger listed under [QUOTE]MyDB->Programmability->Database …

Hi All! I am working with an MSSQL DB which stores images as blob's. When I pull out the blob it seems to be cut off at a fixed length. Every image only displays the top 1/3 or so. My query is very basic and has no limitations in it …