7,494 Archived Topics
Remove Filter  | |
| | I am REALLY new to SQL. Teaching myself C#; downloaded SQL Express 2008. (Not sure of the terminology either...) Successfully created several tables for my desktop customer database. I am not able to populate the database yet... Do I have to create my own application to add data to the … |
| | First let me thank everyone who has answered questions here. I have used this site and others to gain a good understanding of database design. :) Here is my question. When normalizing a database can you have multiple IDs in the same "link" table. Here is an example of what … Databases database-design  |
| | I am using mySQL to develop a database collected from internet sources. Python is used for the spider coding, but I'm having issues with the mySQL portion. I'm pretty new to mySQL, so I'm a bit lost. I need a way to lock a single row of a table and … Databases mysql |
| | Hi, I just would like to ask if there is a benefit regarding this type of relationship between tables. Say I have a table named Student. I usually relate a table (one-to-one) to extend it. What I mean is so as to not put too much columns in Student table … Databases |
| | I'm writing a query to summarize survey results. There are two tables... 1) The Profiles table contains the users' answers. There are four columns: ProfileID (for the unique key), QuestionID (a number representing canned questions from another table), Answer (a number representing multiple choice answers from another table), and UserID. … Databases mysql |
| | Hi, How to find number of rows affected in update statement using mysql (not using php mysql). Thanks, Pradeep Databases mysql  |
| | Dear All, I have developed C# application to import data from CSV to SQL Server using sqlBulkCopy. However I am facing couple of problems listed below 1. whole transfer fails when one record has column width issue (source column width is 30 and destination is 20) so how could I … Databases mssql  |
| | hello everyone..I would be grateful if anybody could help me in performing subtraction from diffrent tables... My Database has a Asset table which has opening balance and balance left coloums in it.and i have one store table which has received/issued item and its quantity.Wat i want to do is if … Databases mssql |
| | I'm relatively new to MSSQL, and I'm trying to improve the DB write performance. I have some legacy Java code that's generating about 1500 records every second. These 1400 records are generated by multiple Java threads. Right now, my approach is to create an SQL statement in each thread, to … Databases mssql  |
| | Hi, I have the following query, which does not return any results. [ICODE] select (sum(t.minutes) / 60),d.fiscalmonthnum from kpifntime t inner join kpiddate d on t.datekey=d.datekey inner join kpidacts a on t.activitykey=a.activitykey inner join kpidfees f on t.feeearnerkey=f.feeearnerkey where a.activitycode in (11,12,13,14,15,16,17,18) and d.fiscalmonthnum=11 and d.fiscalyearnum=2009 and t.feeearnerkey=520 group by … Databases mysql |
| | i have a database containing 100 questions . i want to select random 10 from it. how to do that? there is another database containing 100 questions. questions are stored along with an attribute level. there are 10 levels. so there are 10 records whose level value is 1 and … Databases oracle |
| | hey, first off I'd like to state that I am pretty new to ms sql and stored procedures tho I have worked with sql for quite some time. My employer would like me to write a script which takes html content from a mssql db (originally delivered dynamically) and create … Databases html-css mssql web-server |
| | Hi, As a requirement of one of my assignments, we have to upload images, videos and audio files in a column called fileContents. Earlier I had set the data type for the column as 'Image'. But my professor says that I wont be able to upload Audio or video to … |
| | I need help converting relational model into object-oriented schema.The model is attached so please have look at it Databases |
| | Hi, I've having a bit of difficulty with an update statement. The following select statement returns 34 records... [CODE] select b.* from budget as b inner join ntime t on b.feeearnerkey=t.feeearnerkey inner join date d on t.datekey=d.datekey inner join acts a on t.activitykey=a.activitykey where a.activitycode in (11,12,13,14,15,16,17,18) and b.fiscalmonth=d.fiscalmonthnum and … Databases mysql |
| | like isnull? Is there any way to check if like? select @myVariable isequal("hotta","kutel") If it is equal to "hotta" set it as "kutel" something like this? Databases |
| | Can Crystal Reports be used with MySQL? If not, what reporting tool do you recommend? Databases mysql  |
 | Length/Values1 what do i put there. this is a collumn in one of my tables its bigint so the number can get increased by alot. its a point system. it asks for length/values whn i edit the name of the column but i dont understand what to put there. i … Databases mysql |
| | I have a mysql table that was working fine. I'll try to be brief. I have a table that has two primary keys, both are also foreign keys to other tables. The primary keys are qid and pid. If I try to enter a record, using pid > 10, I … Databases mysql |
| | Hello All. Is there any syntax for [COLOR="Red"]getting fields in a column in an alphabetical order[/COLOR] in mysql? See, for example... I have a two column with "NAME & NUM". NAME NUM BHANU 6 KIRAN 3 ADAPA 8 CHANDU 7 I need to get the names in alphabetical order. There … Databases mysql |
| | its a mess. i dont know why it would be doing this. considering the message it says its in the inbox in the mysql database and then its not. i dont know what to do. its php and mysql database. is there a posiblitily its showing up on the webpage … Databases mysql |
| | I am more interested to know a site that got sample web access code -- to access SQL server / oracle database == could include any of the following language --- c# , vb.net, jsp --- asp, javascript -- ajax answer could be in form of the coolest CMS on … Databases cms mssql oracle vb.net web-server |
| | i m using ORANGEHRM, for dis first of all i installed basi package of XAMPP,i have created my account on the site of orangehrm.The account run on localhost i.e it runs on single system.My problem is i have to RUN IT ON D ANOTHER SYSTEM,is it possible to run d … Databases mysql |
| | Hey all, I'm trying to insert a bunch of rows from an xml document into an SQL database. I have a stored procedure that I'm calling from my program after I generate the XML string and pass it into the SP. It runs with no (visible) errors, but when I … |
| | Hi all, Goodday...! Im delevoping a struts project of my own. Having doubt in database connection. Actually where i have to write code for connection, there itself my doubt starts.... whether i hv to write a connection code in (1) execute method in Action class, OR in (2) servlets, OR … Databases java-netbeans mysql  |
 | Good day All I have a Challenge. I have the Following StoredProcedure that is doing the Following [code] IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[temp]')) drop table [temp] --Creation of Temp1 SELECT MTN.ID,S.DESCR,ISNULL(MTN.CYCLETEMPLATE,C.CYCLES) AS CYCLETEMPLATE into temp FROM TBL_STAFF S INNER JOIN MTM_ACTV_STAFF MTN ON S.ID = … |
| | Hai, Am Using SQL SERVER - 2000 Table Structure CARDEVENTDATE CARDEVENTTIME CARDNO 20090224 92007 485 20090224 92345 321 20090225 163932 168 20090225 164630 471 20090225 165027 488 20090225 165137 247 20090225 165147 519 20090225 165715 518 20090225 165749 331 20090303 162059 240 20090303 162723 518 20090303 155029 386 20090303 155707 … Databases data-structure mssql sql  |
| | Hi all, I need a help regarding with the extraction of a single value from the specific field that contains the datatype [B]nvarchar(MAX).[/B] Databases mssql |
 | Good Morning All, I am not an MS Access Expert, so kindly excuse my ignorance. I received a database which is unable to open on my computer (for whatever reason), but is able to open on 5 different computers. At first I thought it was an MS Office version difference … Databases microsoft-access visual-basic |
| | I have been unable to figure out how to insert data into My database. I am just learning PHP so please ignore comments [CODE] <?php if (isset($_POST['submit'])) { if (isset($_POST['question'])) { $DBhost = "localhost"; $DBuser = "root"; $DBpass = ""; $DBName = "exit_poll"; $table = "exit_reason"; mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable to … Databases mysql |
| | I am trying to connect to a sql server using login which accepts the username and password, instead of storing the credentials in the connection string. But whenevr I pass the variable in the connection string I am getting an error which says login failed for the user. Is it … |
| | Anyhelp with code below would be greatly appreciated Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /usr/home/rconn/domains/dadpop.net/htdocs/online-bookmarks/register.php on line 44 you have been successfully registered. Read your email and click the link to activate your account. [code=language] <?php require_once ("./header.php"); $secret = "dDWUc72sCcs20cXskcw"; $reg_register = set_post_bool_var … Databases mysql |
| | Hi all, I am fairly new when it comes to SQL... and i would like some help I would like to run 2 select statements in the same time...in order to get my results in a table with 2 columns and 2 rows that shows me the result of my … Databases mysql |
| | Hi All, I was trying to research my problem, but wasn't getting any results to satisfy me. The problem is: I am storing data in a mysql database (the server time is stored as well), I am also uploading data into this database from a file that was downloaded from … Databases mysql |
| | hi how can access romote Mysql database from local mysql database. like oracle dblinks will also work in mysql. |
| | Hi guys, A few months ago i installed a version (5.0 i believe) of MySQL on my machine with no problems at all. Two weeks ago i had to format my hard drive and reinstall my OS. I have successfully installed Visual Studio 2005 and tried to install MySQL last … Databases hard-drive mysql visual-studio  |
| | I want to insert an array into a table. Each array element is a row in the table. How can I achieve my goal? I don't want to use [code] VALUES x1,x2,x3,x4 ......[/code] Databases  |
| | Have setup several ODBC links to local access DBs, and thought it would be just as simple wanting to link to an Access DB stored on my personal webspace, but no... Asks for username / password when I type in the url of the online DB in the ODBC setup, … Databases microsoft-access |
| | Hello I am new to this forum. I am using MS SQL 2005 Express I have a database GK.dbo (the original databese) and I have created a database GK_2009.dbo (it is created from the original database, so it has the same structure) I want to create a script that would … Databases data-structure mssql |
| | Hello. I have a MYSQL database and I receive CSV files throughout the day. At present I have to open up my database and import the CSV file. Is there a exe file that can run so the CSV file can be imported as and when it arrives on the … Databases file-system mysql |
| | Hi, I work for a non profit child care centre in canada. We have developed a database for our children's registration, we used access 2003. We're opening a second site and thing it's a good time to reevaluate our database. I'm looking for suggestions on programs to use and some … Databases database-design |
| | I want to get the row number of a specific row in the table. Also is this legal? [code] INSERT INTO (SELECT * FROM myTable WHERE mynumber=2) VALUES ........ [/code]  |
| | Hi all, I have a table named comments having columns id, name, email, comment, commentedon, approved, and approvedon. In some cases I would like to let the admin of my asp.net web page to approve all the comments at once. Which would be the effective sql code and why? update … |
| | i need something like a function to do a specific job which work in a specific time.Like every first day of the year i want to sum all the members account amount to my tbl_information table's column. How can i do that? Databases mssql |
| | All, I have an issues form in a database (MS Daily log) and when you fill in the form it save the data into an issues table. Everytime you do this it gives each issue an ID number (auto number). Basically I want to fill in the form then before … Databases mssql |
| | Hi, I have a table like this: [code] name +------------------------------------+ | name | +------------------------------------+ | This is an rna-binding protein. The data which is useful is available from the desired location. | +------------------------------------+ 1 row in set (0.00 sec) [/code] I want to remove extra space i.e in between binding … Databases mysql |
| | Hi All, I have four different tables in my database with following structure: //=================================================================== 1. [B][U]customer[/U][/B] [I][INDENT]customer.CustomerName, customer.CustomerHouseNo, customer.AreaID, customer.CustomerID, customer.CustomerType, customer.CustomerBalance, customer.CustomerAdvance, customer.CustomerMonthlyFee, customer.Remarks, customer.CustomerConnectionDate, customer.CustomerStatus, customer.CustomerTelephone, customer.EUserID, customer.USerID, customer.EditDate, customer.CDDate, customer.DisRemarks, customer.CtypeID, customer.CIP, customer.CMAC[/INDENT][/I] 2. [B][U]payments[/U][/B] [I][INDENT]payments.Amount, payments.PaymentMonth, payments.PaymentDate, payments.CustomerID, payments.PaymentYear, payments.CustomerAReaID, payments.ReceiptNo, payments.USerID[/INDENT][/I] 3. [B][U]area[/U][/B] a[I][INDENT]rea.AreaID, area.AreaDesc … Databases database-design mysql sql |
| | Has anybody used this microsoft tool SSMA? I can connect the two databases OK, and can convert tables from ORACLE to SQLSERVER 2005, but the data refuses to go across. Any info will be helpful. Thanks, Jim  |
| | I have joined a few tables together and all seems to work well.. [code] SELECT * FROM products JOIN underwriters ON (products.underwriter_lookup = underwriters.id_uw) JOIN countries ON (products.country_lookup = countries.id_co) JOIN repay_types ON (products.repay_type_lookup = repay_types.id_repay) JOIN base_rates ON (products.base_rate_lookup = base_rates.base_rates_id) [/code] However, I have been asked if I … Databases mysql |
| | Hi, I'm pretty new to the whole SQL thing, and i'm basically self teaching using manuals, online help and the fact i pick things up quickly. I'm having a bit of trouble picking data up from 2 tables and i think i'm just beign really thick. This is what i'm … |
The End.