Databases Forum

Hi all, I have a java database application which mainly deals with database operations. Im concerned about the performance, as I have many update statements. As there are many records, each row has to be updated with a calculated value. So can anybody help me out to suggest for efficient …

Hey All, I have tried to work on a way to update all the date in a row called: "position", from a table called: "pages". The admin have a choise on where to place his new page, in the cms. The pages/links, are being pulled from the database by position …

Hello, I'm trying to sort a training table in order of the sequence of tasks. These tasks are numbered 1.1.1 1.1.2 1.1.3 ...... 1.1.10 1.1.11 When the query sorts this and displays it, it comes up: 1.1.1 1.1.10 1.1.11 1.1.2 .... Is there a way to get them to come …

Hi Guys, I am trying to make a connection with Oracle 11g which is installed on a server 2008 BUT have problems with the ConnectionString. Could you please let me know how I set a correct connection String while I have parameters like these: Database name: GISData Server Name : …

I am using Oracle for the first time.I installed Oracle SQL*PLUS ver 8.As I had to learn this for an exam. But I am facing the following error after I enter it with the system default scott/tiger ... "ORA-12203: TNS:unable to connect to destination" Sorry ,if this question is already …

Hello, I'm doing a sql database as a school project, the database will be a book catalogue of sorts. What I would like to do is store a biography for the authors and a summary for each book only I'm not sure what the best way to go about storing …

Hi, I am using mysql 5.0.77. I am running queries like create table T1 as Select t1.arg0 as ARG0, t1.arg1 as ARG1, t2.arg0 as ARG3 from table t1, table t2 where t1.arg0=t2.arg0 I want to create the table if the select statement does not return an empty resultset. If I …

Hey all, Can anybody tell me what is a stored procedure an what is the difference between a stored procedure and trigger? Thanks In Advance

Hi I there a way to make a trigger completely independent from the calling table so that even if the trigger is made invalid, inserts can still be done to the table that calls the trigger? I created the following trigger: [CODE] CREATE OR REPLACE TRIGGER LOCAL.SYNC_TRIGGER AFTER INSERT ON …

Hi guys, I'm trying to build a query that involves two tables, the course table and the studentsLink table. The StudentsLink table describes the link between students and the course. The tables are as below; Course courseID(bigint) - PK courseName (varchar) courseInstructor (varchar) StudentsLink courseID(bigint) - PK StudentID(bigint) - PK …

hi how to do insert ignore in access? is access support this function? [CODE] CurrentDb.Execute "INSERT IGNORE INTO FullDB (IDProc, IDOp, IDTech) VALUES (" & IDProct & "," & IDOpt & "," & IDTecht & ")" [/CODE] or how can i do a search for duplicate record first before insert? …

hi all, How to check if a particular row is exist before inserting it? my table has ID as Primary key, and 2 other columns, say Process and technology.. thank you

Hi, I my admin area, where the administrator can create a new page, it is also possible to decide the position of the link. It is a menu in the left side of the screen, one link on top of the other, very simple nav. I have a dropdown list …

Hi, I have one question: I am programming with PHP, CodeIgniter. But it may suit for other tools as well. I need to delete something from the table and I want to be sure that there will be deleted row from another table. In short - delete to rows, each …

I have 2 places I'm stuck on with my DB design.. 1************************************************************************** how to translate ERD that looks like this into real tables? [URL="http://schemabank.com/sites/default/files/images/notation_self_relationship.gif"]http://schemabank.com/sites/default/files/images/notation_self_relationship.gif[/URL] my entity is "Course", if before student wants to take some course he must take few pre-courses then how should I model this? tableCourse- [U]id[/U], name …

Hello Everybody! I have the following problem: I want to make an application, which need tables to show, edit, etc. You would be able to select the table, which you want to work on, by a dropdownlist (the whole project is in ASP.NET). I want to load the selected table's …

Hey all, Is there any way to check the time of insertion of a record. Means if i inserted a record in table on 03/21/2011 14:05:45 00:00 then is there any way to get this time after-wards

Hi, I have a table on two different database servers on server-1 it contains almost 2090 records and on server-2 it is empty i want to copy all the records from server-1 to server-2 both the database servers are identical but on different location and have no relation with each …

good day for all i want to know how i can make linked tables in access with sql server 2008 i tried with odbc in access 2003 but i can not please help me i tried with Microsoft SQL Server Migration Assistant 2008 for Access but i can not

Hello folks, I beg your pardon if I have posted the thread in wrong forum. But my query is related to sql server and visual basic 6, so I thought posting it here rather from visual basic forum will help me getting most replies.... I have developed an client-server based …

i would like you to help me to build my school database query rightnow

hi all hope some one can help me out im a php guy and ive got an application i want to make that will run on windows and ive never program for desktop before and i really need some advice. here is the scenario iv got my website with a …

Hi,i am looking for a light relational database server with the ability to recover after a crash.I am not looking for sqlite or any other single file db system.

Hey All, Can any one tell me how two remove duplicate records from a table?

Hi Guys Could you please let me know what SQL query I can run to get the parent of a specified table? I already used this code which is providing a list of child tables [CODE] SELECT object_name(parent_object_id)As 'Childs List' FROM sys.foreign_keys WHERE object_name(referenced_object_id) ='Stores' [/CODE] How can I run …

I am trying to create a view and by linking two tables together, VLP_QC_Results_Batch1000 and VLP_Stock_QC1000. (see below pics) The issue I have is in the VLP_QC_Results_Batch1000 has the testNo within a field called TestNoName and is separated by a “-“ I need to link these so that we can …

Does anyone know how to programically create an html document for an Access WebBrowser control? For instance, in Access 2010, to browse to a webpage, say [url]http://www.daniweb.com[/url], then assuming you have a WebBrowser control named "webBrowser", then you would use the following: [CODE]Me.webBrowser.Object.Navigate "http://www.daniweb.com"[/CODE] Now say, you want to dynamically …

Hi All! I have made a small cms using php and mysql - I havent tried to export a databae to a webserver before, so I need a little help/confirmation. When I click export in phpmyadmin, and chooses type to be SQL, and saves it with the allready chosen/marked boxes, …

afternoon everyone, I am new to using MSSQL and need help with SUBSTRING function. i have a strings like below s2-Total Solids - Std Method V1E-RVT4/2.5@20degC Initial V1Y-LVT2/60@20deg Initial A2-Alkalinity - ISO Method(%) I would like to only get the data before the first "-" IE s2 V1E V1Y A2 …

So how can you tell if you've maxed out express and need to move to the full blown version. Not referring to database size but performance? Asking because we are moving a website and the webhost master asked if he will be on express or full version claiming that express …

HI I want to create new sql account in sql server 2005,and user only able view sql agent job history details only.How do I do this.Please help. Thanks Tank50

I am having great difficulty getting a query to work with multiple conditions. I have a very basic understanding, hence the two queries below (one commented out). I understand a smaller and more precise query would be returned by using INNER JOIN. Both queries work fine until I try to …

Hi, If anyone can help me with this would be very mych appreciated. My problem is I have a database full of users that has been built up over the years. The password field in the db is not been encrypted and the password is visible to all. I would …

Hey all, I am new in SQL my problem is that I have to select one by one to perform certain function can any one tell me how to loop through the records of a table. I have googled it a lot but still not able to sort out this …

Like the DESCRIBE statement used to view columns in a given table, What SQL statement can i use to view the tables in a database. (Oracle 10g)

I am fairly new to MySQL and having some problems figuring out how to format a couple queries using the following database: branch ([U]branch_name[/U], branch_city, assets) customer ([U]customer_name[/U], customer_street, customer_city) account ([U]account_number[/U], branch_name, balance) loan ([U]loan_number[/U], branch_name, account) depositor ([U]customer_name[/U], [U]account_number[/U]) borrower ([U]customer_name[/U], [U]loan_number[/U]) I need to find all customers …

I wasn't sure which section to post this under but I am working on an assignment in SQL and have created a batch file to make the tables, load the data into the tables, and then sends several queries to sql to get results. Is there a way I can …

Hey guys i d like to pick your brains about something.. Suppose i want to create a database for storing, lets say computer stuff, parts, hardware, peripherals etc.... Which way would be better? 1 ------ Create a Basictable with all the common fields (like ProductName, Price,Guarantee....) and then create multiple …

Hello All: I'm setting up a client management application as a hosted service; whereas the application itself will be accessed and ran from the internet. The application currently runs on one database and 9 tables for each client's account if I were running it on a standalone single system. Now …

i have a very simple S/P called ClaimTotal [CODE]CREATE PROCEDURE ClaimTotal @Result varchar(50) OUTPUT as select sum(total) as Ctotal from claim[/CODE] i am struggling to get the Ctotal saved into the @result so that i can then pull this into my .net program. if anyone could help that would be …

hi, I'm using xampp. By using phpMyAdmin, [CODE] select now() from dual [/CODE] it shows [B]2011-02-14 07:28:57[/B] but suppose today's date is [B] 2011-02-15 07:28:57[/B] is there anyone have rough idea where the date set? i've check the server date is correct 15 feb thankx

Ok here is my assignment. I will admit that it is homework - but I just can not seem to see relationships and building the ERD's that my instructor wants. I think it is his accent or maybe I can not follow too good. In any event, I have not …

I need help creating the tables for my database, I've got all my tables to work except the first one. For some reason it says it is unable to create the first table and i get this error " ERROR 1005 (HY000): Can't create table 'jfunchio.rental' (errno: 150)" I was …

Hi, how to do an access right Administrator can add users while the rest of the users can only view the data? Thanks.

Hi, I'm fresher for sql injection, i have already worked and having a good knowledge about the MY sql server 2000, 2005, and 2008. Did anybody can able to give me steps and how to work in sql injection, as a part of testing engineer. Kindly send me the links …

I keep getting the "ERROR 1005 (HY000): Can't create table 'jfunchio.rental' (errno: 150)" error where i run this code. I was wondering if anyone could help with what is wrong. I would really appreciate it. My code is below. [CODE=sql] create table rental ( item_rental_id varchar(8), customer_id varchar(8), movie_id varchar(8), …

i'm working on building my website but i'm facing stupid problem.. i don't know how to create a php file for my html's one to then connect them to the database .. i need my page to able me to insert,update and delete records from my database, and then submit …

IIf(Time()>=TimeValue("00:00:00");IIf(Time()<=TimeValue("07:00:00");Format(Now()-1;"dd mm yyyy");Format(Now();"dd mm yyyy")))

Hi guys I newly started learning oracle.I'm working on my assignment and I'm stuck in this step because of a silly error and I'm sure of my syntax. It looks fine to me but I get this error: ORA-00907: missing right parenthesis This is the command: CREATE TABLE WORKER ( …

Dear All, For now I have two tables as below. The tblTyre store all the tyres.Then tblTyreConfig store the relevant tyreID in each of the column for instance fl(front left wheel),fr(front right wheel),b1LI(back first left in wheel),b1L0(back first left out),b1RI(back first right in wheel),b1R0(back first right out),b2LI(back second left in …