Databases Forum

what is major differences between sql server and oracle?

Hi friends, In my project I'm using multiple tables to sotr the details.There is one main table and in the i'm storing the contact details of the family.And according to the number of members in the family I'm saving the member names and ages in different table.Now what I need …

hy, i have 2 database. DB1 & DB2. i create SP in DB1. in the SP, i want to access table "TBL" in DB2. how can i create that SP?? [CODE] CREATE PROCEDURE test AS BEGIN ?????????? END; [/CODE] Thx,

hi there......... i am using MS SQL i have made a database in MS SQL now i want to export to another computer (pc) ,,,,,, please help me out with this......... thanks

Less than a year after launching its high performance computing strategy, Microsoft finds its [URL= http://www.microsoft.com/hpc/] HPC Server 2008[/URL] near the top of the heap. The Windows Server 2008 derivative placed 23rd on a list of the 500 top-performing supercomputers in the world, as measured by the [URL= http://www.ncsa.uiuc.edu/] National …

hi, im making a vb.net app to make a backup of a mysql database on a remote server. i could do it easily with just one select and then a loop for all the inserts but the thing is, single inserts for lots of rows are really slow and here …

Hi , I want to create user defined data types in MS SQL 2008, So when I start MS SQL Server Management Studio -> Database here 'Adventure Work' is not appearing. ( I am referring this -http://www.mssqltips.com/tip.asp?tip=1628) how to enable that?:?: or is their any another way to declare user …

I want to combine the following select statements so I can have 1 export file rather than 2. This code selects student information along with their HomeRoom teacher. [code]SELECT students.last_name, students.first_name, students.grade_level, teachers.last_name, students.student_number FROM students JOIN CC ON students.id = cc.studentid JOIN teachers ON teachers.id = cc.teacherid WHERE (cc.course_number …

Hi All, Can anybody put me in the right direction for counting empty cells in a row? Thanks

I have two tables: [B]1st Table Name : country[/B] [B]Table data:[/B] [CODE]------------------ ID | CountryName | ------------------ 1 | India | 2 | Japan | 3 | China | 4 | Canada | 5 | Denmark | 6 | Egypt | 7 | France | 8 | Germany | 9 …

Friends, in my project(i'm using php and mysql & i'll be getting all the detail from th user) I've to create a seperate ID for each family. For each family I've to maintain the family members details and the contact details.Now wats the problem is how can I add or …

Thank you Hi, I am Asha Bhatt I have created one table (Question) , which contain 500 of row and 6 column. column name are QusID , Question , Option1 ,Option2 , Option3 , option4 . and in asp.net i have one button and one lable . when i click …

Hello. I am having trouble with a count col query I hope some one can help me with. I have six questions and I would like to count how many "yes" answers in each col and then group by that col. Here is my schema table:survey ||id || Q1|| Q2|| …

I just loaded the 10g client EM on my Windows workstation to connect to our 10g database. Everything works great except I dont see any place where I can edit records. I have to use SQL Plus to edit records but was hoping to use a GUI like I had …

Hi guys; I need your assistance. I am extracting some info from my database and I need difference between two fields of money values. Lets call the fields as Field1,Field2,& Field3. Field1 = Current Balance Field2 = Starting Balance Field3 = Field1 - Field2 From my query, I get Field3 …

I was hoping that there would be a readonly system or session variable such as @@username or @@user_id or similar Is there any way I can access username information inside an SQL database please? I am hoping to use it to render certain ROWS visible/invisible in views This would be …

I have 2 tables, 1 called journeys, which contains the journeyID, the start station, end station, time to complete, and the distance. The second table is called connections and contains all the stations the train stops at along the journey. I need to write a query which extracts the correct …

Hi! This is for a homework assignment, and I'm trying to do cascaded deletions on tables that refer to each other. [B] Homework question:[/B] Give an example instance of C and D, having at least 4 tuples in each of C and D, such that a deletion of a single …

:icon_confused:I have made the change from access to mysql. I am using vb6 to connect. The connection seems to be fine, it was some code sample that I have downloaded from the net. The app is reading the databases, but as soon as I select a database, i get an …

Hello, Now i have 3 tables which are: [CODE]CREATE TABLE IF NOT EXISTS experience( experience_id int(11) NOT NULL AUTO_INCREMENT, salarie_id int(11), consultant_id int(11), post varchar(255), entreprise_name varchar(255), start_time varchar(255), end_time varchar(255), description varchar(10000), PRIMARY KEY(experience_id) ); CREATE TABLE IF NOT EXISTS salarie( salarie_id int(11) NOT NULL AUTO_INCREMENT, name varchar(255), ..., …

I had built a small cRM database in MS Access. The database is outgrowing its life in access so i was thinking of porting the backend to SQL server express. I was curious on what people's favorite/best frontend for forms and reports was. ie keep my access forms/reports on top …

I have 3 tables. Locations, Units and phases. Each location can have multiple units and each unit will have multiple phases. Hence my database structure consists of foreign key associations as follows. 'Units.location_id' references 'Locations.id' 'Phases.unit_id' references 'Units.id' When I delete a Location, all associated Phases of the Location and …

hello all I have Table1 and table2 table1 design is Name ,varchar amount , decimal table2 design is Name , varchar nominal,decimal how is the statement to find the sum of amount in table1 plus the sum of nominal in table2 ? thank you denny

Hi All, I have a table in mysql in which there is a column which have following kind of data $Category=>Income;$NAV=>10.2181;$Repurchase;Price=>0;$Sale;Price=>0;$Date=>26-Feb-2008; I want to Bifurcate the data in that column into 5 separate columns in the same table in this way $Category=>Income in this thing "Income" in column "category". $NAV=>10.2181 …

hi every1 i m creating a simple ms access project. i created a report ,when the user opens it,it opens a query which askes user to enter name. the user enters the name and the report by that name generates. is there a possibility that when the name is asked …

Hi all I have a little problem. I have a table that has up 300 rows in it. There is a column where a day and date is inserted. The data looks like this: Monday, 08 March Tuesday, 09 March Wednesday, 10 March Thursday, 11 March Friday, 12 March Right …

Hi! I'm using various CMSs on my server and since I don't know PHP coding and also don't have the time to modify the scripts, I'm searching for an easy way to disable the MySQL errors. I'm talking about the errors that show in browser whenever the database table is …

Hey, I'm totally new at database design, and can't for the life of me decide how to design my system. I have categories, which contain sub-categories, and in these sub-categories are items. For example: Wedding Music (category) ---> Bands(sub-category) ---> Awesome Band (item) What I'm trying to do is achieve …

Hi, Can anybody tell me how to make a button in an access form that connect me to a website?

I have a table that looks like this: [code] Database: Testdb Table: Testtable ID | Value -------------- 1 | 105 2 | 105 3 | 105 4 | 105 1 | 255 2 | 255 2 | 311 3 | 311 4 | 311 1 | 500 3 | 500 …

I am trying to insert a SampleID(autonumber), ArticleNo(number), and SamplePoint(Text) into a table set up for the results. I need the Sample ID, ArticleNo and SamplePoint to tie the results table to the Samples Taken Table. I have searched the internet and tried several different samples that have not worked. …

I am trying to write my first sproc that inserts values into a table. These values will be entered by the user and stored in a variable . They will then be added to the database. This is what I have come up with so far. I can't seem to …

I have this table publication_en Field Type related varchar(200) public_area int(11) title text detail text file varchar(200) and i am trying to do this INSERT INTO publication_en (related, public_area , title , detail , file) VALUES ('none','1','"helped"','la' "kajakjajk"','J3.pdf') but it doesn't work any idea why it doesn't work ? Thank …

Good Day All I have an Sp and UDF. the UDF cant take #tables. so i want to incorporate the functionality that is being provided by the udf and make it part of the code. the first part of my statement creates a solid table that is being used in …

Does anyone know anything about Oracle Roles & privileges. An application on 9i has multiple roles assigned to each user. I am getting permissions problems, I think because there are conflicting privileges within the roles. EG: Role1 has SELECT, UPDATE on table1. Role2 has SELECT, INSERT on table1. User Default …

Hello everyone I am new to access and have been trying to teach myself a bit lately. In any case, I have a problem with a specific text box(NumofMonths) within a form. I need for the default value to be 12 and that it may be edited. This text box …

how to use database tags.?? what exactly is the use of it.?? In my database design i have a table called project_details which consists of many fields like its projectID, title, domain and technology. Each project can have many technologies involve in it.. so how do i make use of …

Dear all, Good Day I need your help, I have the attached files that contain a data for "queue system" and I can get report from them by the q-system application But I search for another way to open this file as (SQL, Access or other) If you can open …

Many people would probably think this question is stupid, but how can i insert a value that starts with 0 in a Bigint/Numeric/Int field? This would normally not be a problem, just using a varchar field instead, but because of the index speed (this is a very large table with …

Hi, I want to learn sql injection.I searched in google but the information is not sufficient to me.Will u provide some links to learn sql injection. thank u

Hi everyone, I have a query as - [COLOR="Red"]select DateName(Month,Date), avg(NetAmount) as AverageCustomerBill from salesmaster group by DateName(Month,Date)[/COLOR] which gives result as follow - [COLOR="Green"]April 451.5664 August 432.6227 July 441.1437 June 429.9915 May 423.7198 November 407.4123 October 425.1684 September 416.3678[/COLOR] As u can see here Months are not in proper …

i have some problems with mysql database query and its as below : Tables : i) departments id department description ii) farmers id name sex address age category remarks iii) scientists id departmentid name remarks iv) scientistvisits id scientistid farmerid datevisited purpose remarks Here, i want the query of number …

Hello DaniWeb Community! I am trying to create a web page that utilizes Ajax and PHP to connect to my mySql database and look up a username and password. You have all most likely seen the web page that has the template code on it: [url]http://www.phpeasystep.com/workshopview.php?id=6[/url] This code is nice …

Hi friends, I have a form to create a company details.. which will insert the details into a table. For this table, I need to have a auto increment field as character.. when we have autoincreament as Integer... whenever the new company is created..the number will increase from 0, 1, …

Hi, I have developed a database web application, in that, a database has 2 tables with same structure. I am using MySQL querybrowser to add, update and delete the records. So, now my question is how can I move the tables records from one table to another, without writing a …

the deal is to create trigger(function?) which would send updated value from one table and add to another example: table1 column:AccountID and 2 column: Money table2: column:AccountID and 2 column: Money i create something like this: [code]CREATE TRIGGER money_from_vault ON table1 FOR UPDATE AS DECLARE @Money Int,@AccountID varchar(10) SELECT @Money …

[CODE]select distinct cust.no, cust.branch, cust.name, cust.surname, term.benefit, term.code,tehi.trcode, tehi.trancode, dmhi.trancode, dmd.benefit from cust as cust inner join term as term on cust.rowno = term.rowno_custterm_cust inner join tehi as tehi on term.rowno =tehi.rowno_termtehi_term inner join dmd as dmd on cust.rowno =dmd.rowno_custdmd_cust inner join dmhi as dmhi on dmd.rowno =dmhi.rowno_dmddmhi_dmd group by …

Hi all... Im having some trouble inserting values to my mySQL database. I have the following installed on my local system. [B]MySQL[/B] Server: localhost via TCP/IP Server version: 5.1.43-community Protocol version: 10 User: root@localhost MySQL charset: UTF-8 Unicode (utf8) [B]Web server[/B] Apache/2.2.14 (Win32) PHP/5.2.12 MySQL client version: 5.0.51a PHP extension: …

i have supertype-subtype: supertype: document subtype: clearance, sedula this query: [CODE=mssql] SELECT Document.DocNo, (Person.Givenname + SPACE(1) + Person.Middlename + SPACE(1) + Person.Lastname) AS Name, Person.Address, CASE WHEN DATEADD(YEAR, DATEDIFF (YEAR, Person.DOB, CURRENT_TIMESTAMP), Person.DOB) > CURRENT_TIMESTAMP THEN DATEDIFF(YEAR, Person.DOB, CURRENT_TIMESTAMP) - 1 ELSE DATEDIFF(YEAR, Person.DOB, CURRENT_TIMESTAMP) END AS 'Age', Person.Status, Person.Picture, …

i have a supertype-subtype: supertype: DOCUMENT subtypes: CLEARANCE, TAX CERTIFICATE, RECEIPT, BUSINESS CLEARANCE each clearance subtype may have a TAX CERTIFICATE, how could i join using join? in other words, document>clearance document>tax certificate i want to join document>clearance and document>tax certificate into a SINGLE view help. thanks