7,494 Archived Topics
Remove Filter  | |
 | how dataware house is different from traditional database ? examples Databases |
| | Hi all, I am working on the following code. In the SQL query, I am currently calling all the data from the DB using * and all works fine. I would like to be selective and call the coloumns required i.e UserID, UserFullName, UserEmail, UserLastPassword, but when I do this … |
| | I have the following sql query in vb.net and ms access , how do I create a table from the query result ? `SELECT 'Table1' AS [Table], SUM(a) - SUM(b) AS Result FROM table1 union all union all SELECT 'Table2' AS [Table], SUM(a) - SUM(b) AS Result FROM table2 I … Databases mysql |
 | I have a search script that searches my database for a particular property address, but I have a problem displaying all the records ... my script is displaying only one record no matter how many records exist in the database with the same property address. I have two tables in … |
| | i almost spent 3 hours on EXISTS operation, used in SQL especially with subqueries, i got its purpose :) that's ok but what i don't get is that WHY TO USE IT ? e.g. couldn't understand this example: *TABLE STORES* storeName----Sales-------Txn_date *TABLE GEOGRAPHY* regionName----storeName SELECT SUM(Sales) FROM Store_Information WHERE EXISTS …  |
| | After installing Oracle 8.06 on Windows XP (Pentium (R) D CPU 3.2GHz 3.20GHz - 480 MB RAM). I'm Attempting to run "Oracle Net8 Easy Config" when error comes up saying "jre.exe has encountered a problem and needs to close.." I tried: -Doing a system restore and installed it again (after … Databases oracle |
| | ALTER FUNCTION [dbo].[customers_udfMin2] ( @decission tinyint ) RETURNS int AS BEGIN -- Declare the return variable here DECLARE @min int Declare @default int = 10 -- Add the T-SQL statements to compute the return value here if (@decission = 1) Begin SELECT @min = MIN(customers.cus_id) from customers End else RETURN … |
| | display city_name using two tables. I have written two queries but unable to display the results. First Table name is tbl_city and it has id,state_id,city_id,city_name. Other table name is tbl_states and it has id,state_id,state_name $state_id=$_REQUEST['state_id']; $query="select c.city_name FROM tbl_city AS c,tbl_states AS s where c.state_id='$state_id' AND s.state_id='$state_id'";(two tables using alias) …  |
 | What's the difference between char and varchar in phpmyadmin ? I am trying to decide whether to use char or varchar for name for example. Databases mysql |
| | I'm trying to display some records which meet some certain criteria. That works fine, but I also want to retrieve the total amount of orders. These are all located in the field 'Amount' from the Orders table. So if record 1 has got '22' in it's amount field, and record … Databases mathematics mysql  |
 | When I run: ---`mysql> SET PASSWORD FOR 'garrett'@'localhost' = PASSWORD('abc123');` I get: ---`ERROR 1133 (42000): Can't find any matching row in the user table` Also, when I run: ---`mysql> UPDATE mysql.user SET Password=PASSWORD('abc123') WHERE User='garrett' AND Host='localhost';` I get: ---`Query OK, 0 rows affected (0.00 sec)` ---`Rows matched: 0 Changed: … Databases mysql |
 | I'm taking a database class, to be more specific MySQL. I want to know if I will use this if I enter the programing field as a C#, C++, or Java programmer. If so what will I need to know |
 | Last week, the NoSQL database host MongoHQ suffered a breach which exposed customer files, email addresses and password data to the attackers. The ripples from that breach are still being felt, as users of the Sunrise calendar app on the iPhone found out this morning. Luckily that password data was …  |
| | drop trigger if exists update_asset; drop trigger if exists insert_asset; drop trigger if exists process_asset; delimiter | create procedure process_asset_calc ( in name varchar(50), in cost decimal(20,2), in life int(11), in whenacquired date, inout Months_Depreciated int(11), inout Accumulated_Value double(2,0), in residual_value double(2,0), inout Monthly_Depreciation double(2,0), ) BEGIN set Months_Depreciated = … Databases mysql  |
 | Hi I have this list: 532790M 47448M 378267M 467981M 53661M 583783M 524687M 390963M 493436M 185366M 150370M 497092M 3660G 568961M 152693M 254278M 353173M I am running an Access Query and I am trying to figure out what criteria do I need to insert for just showing only two digits before "M" … Databases |
| | Hello! I am editing my website to make it more updated and have created a new couple of pages which use my Database. I created the script and the databases (and tables) and everything was working OK... until somehow the tables have got partially deleted. I say partially because if … Databases daniweb-bug mysql |
| | i'm trying to access a database backup that i usually keep in my pc's hard disk, trying to access it via my laptop. Both pc and laptop has SQL SERVER 2008 with same server name, using windows authentication, i spent 2 days but can't figure out that how to access … Databases mssql  |
| | Hi, I am having an issue, any suggestions will be great. I am trying to fetch records from 3 tables on conditions to retrieve the correct data. So far it brings up 2 of the same results as there are two image file names with the same product id's in …  |
| | Hi I am currently searching for entities in this case study and I am hoping to create an entity relationship diagram after I have found all the entities. So far I have managed to come up with the following entities Members Group members Organised club racing Training sessions Boat Design … Databases database-design linked-list session |
 | When I try to migrate from SQL Server 2000 to SQL Server 2008 R2 Express, when I run the application program there is an error message transaction aborted by the trigger, whereas before when I was using SQL Server 2000 does not exist error. after there was a note on … Databases |
| | Create Procedure `SelectProduct` (IN prod VARCHAR(70)) BEGIN SET @sql = null; SELECT GROUP_CONCAT(DISTINCT CONCAT( 'max(case when Attribute = ''',Attribute,'" Then p.Attributevalue end) as `',Attribute,'`' ) INTO @sql FROM tblAttribute; SET @sql = CONCAT('Select pr.product, ',@sql,' from tblproduct tblproduct pr LEFT JOIN tblproductattribute p using(productid) left join tblattribute a using (attributeid) … Databases mysql |
 | How I can create .mdf file from MySQL; if yes then HOW and if not then which tool do I use create .mdf from MySQL ? Databases mysql |
 | I have a table (employees) like this ID Name Group Email 1 Bob Buckland Marketing b@example.com 2 George Alaz Engineering g@example.com 3 Tom Grady Marketing t@example.com 4 Mary Jane Engineering m@example.com Im going to use this in a email form. First a combobox should load all the groups possible. This … Databases engineering mysql |
| | Hi, We have MS sever 2012 and MSSql Server 2012. ODBC Connection in Server is fine. But If create the odbc from Client PC (OS Windows 7 profession SP1), it could not connect Error : Server not found or Access Denied. Even in Admin level also, it shows same error. … Databases mssql |
| | How do I connect from another machine to SQL Server 2008 R2 Express installed on Windows Server 2008? I've setup the network configuration to be enabled and the TCP port is set to 1433, but I still can not connect to an existing database on the server when creating ODBC … Databases client-server mssql sql |
| | Hello people, I declared a field in my table : [B]my_field VARCHAR(20)[/B], but I don't want it to contain any number: can you tell me how I can do that using a trigger or using a constraint ? Thank you in advance for any help Databases oracle |
 | I'm working on a School's fee management module. The client's requirement is: 1. There are 6 types of fee to be paid: * Annual Fee * Tuition Fee * Exam Fee * Games Fee * Development Fee * Other Charges 2. Only tuition fee will be paid monthly and rest … Databases database-design mysql web-design  |
| | Can anyone please help I'm having an index error with my php code. When I run the code I get the errors Notice: Undefined index: name in C:\Program Files\EasyPHP-5.3.9\www\Authentication1\update1_ac.php on line 9 Notice: Undefined index: surname in C:\Program Files\EasyPHP-5.3.9\www\Authentication1\update1_ac.php on line 10 Notice: Undefined index: contact_number in C:\Program Files\EasyPHP-5.3.9\www\Authentication1\update1_ac.php on … |
| | Good Day, I would like to ask if it possible that i have my Local Database(MSSQL) but i would like to put it Online? I need some idea on this Daniwebers. Your response is Highly Appreciated. Thank you, EOS Databases mssql |
| | Hi, I'm sorry if I had post duplicate post. I had join this 2 table (dt_dict_tbl - store dictionary, sdn5_5 - store accumulate value for reporting). Here the table structure **dt_dict_tbl** CREATE TABLE `dt_dict_tbl` ( `dtDictCode` VARCHAR (30), `dtDictDesc` VARCHAR (600), `rptCode` VARCHAR (30), `rptSubCode` VARCHAR (30), `dtCreatedDate` TIMESTAMP , … |
| | Having to create an ERD diagram from the following scenarion any help will be much appreciated Appendix 1 Case Study: Scenario - Global Trading PLC Global Trading PLC is a mail order company that operates a number of different catalogues. Each catalogue addresses a specific market segment and the company … Databases data-structure finance storage |
 | Hello. I am currently studying database design at my local university. They use Microsoft products there (Microsoft SQL Server 2008/2012), but we can't use them at home because of the licensing. I have two questions: 1 - Is there anything in the world of Open Source that I can use … Databases database-design open-source sqlite visual-studio |
| | Question: Given the relational schema: ENROL (S#, C#, Class) - S# represents student number TEACH (Prof, C#, Class) - C# represents course number ADVISE (Prof, S#) - Prof is project guide of S# PRE_REQ (C#, Pre_C#) - Pre_C# is prerequisite course GRADES (S#, C#, Grade, Year) STUDENT (S#, Sname) - … Databases mssql |
| | Hi, Need Help regarding a query. I want to search all empName from emp table whose name 3rd letter is "s" Databases mysql |
 | Hello, I am working on a query for a dog agility venue where it's calculating award requirements. There are two columns that are identifiers, one is the RegNum which is the dogs identification number, and the other is Class_Subset, which identifies which class the points were earned under. And then … Databases mysql |
| | hey all I just need someone who can explian to me what the ESCAPE keyword does here ?? nd what the deference if I remove it ?? SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA\_%' ESCAPE ''; note working on the sample database SQL developers Databases oracle |
| | delete hash from users where email='emailaddress@hotmail.com'; Why is the above line not working? I want to delete the value in the hash column in the row the contains the specified email. Databases sqlite |
 | I have a temp table that is used in a union. But it resulted an error saying "cant reopen table". I've read that I need to rename the tempTable. How could I rename a temporary table when I'm using the tempTable in a union? Databases mysql |
| | Hi,i have this tblProductAttribute with ProductAttributeID|ProductID|AttributeID|AttributeValue| 1|1|Blue 2|2|medium (AttributeID 1 = Color,2= size) i want to get result from select query like this ProductName|Color|Size sampleproduct|Blue|Medium inshort i need to get row data to be the column name please help me.thanks :-) Databases mysql |
| | Example 1 below works: echo "<p><h2>".$results['title']."</h2>".$results['shortdesc']."</p>"; I need to make the title linkable to the page url. I'm probably putting the ' and " in the wrong places for the link part. Example 2 - I've added the url code but does not work: echo "<p><h2><a href=http://www.example.com/".$results['url'].".$results['title']."</a>"</h2>".$results['shortdesc']."</p>"; Any help would … |
| | Hi all, I have a project that I'm going to do.There's a table that has to be normalized.i need your solution just to check mine with yours.Here's the table with sample data. I have taken Pay Item as a primary key: Pay Item Description BridgeType Span Unit Quantity 81.02(a)-I Soft … Databases  |
| | Hi All, Firstly I will say that this exercise is for my learning experiences through an online course. However I have spent a combined total of about 6 hours working on this question and I am completely stumped on how to get the correct answers. The question: > List the … Databases mysql |
| | Hi, I want to know that how can I get the timestampdiff return as zero instead of null. For example I have a query in which both dates are exactly same but the query returns me null instead of 0. My query is SELECT (TIMESTAMPDIFF(HOUR,'2012-12-01 11:15:00','2012-12-01 11:15:00')) And this code … Databases mysql  |
| | Hi I am starting my final year project and was wanting to know how to connect visual studio to my database. I am using phpmyadmin which is on the uni's server so I can work on it at uni and at home but I am having trouble finding out how … Databases mysql visual-studio |
| | Hello, I am a student and I was assigned to create my first entity relationship diagram and I'm kind of lost. The professor hints the paintings should be broken into a generalization hierarchy since they have so many attributes but I can only break them into two sub(entities) based on … Databases database-design pdf storage |
| | hi everyone, i have a database table that was getting large.... i deleted all the entrys to start again but each time i add a new entry the id is continuing from the deleted list? so instead of going 1 2 3 etc, its starting from 664, as if the … Databases |
| | i want to calculate the depreciation of an asset and i want my accumulated value to automatically add the previous monthly depreciation value with the current one any time the user calculates for the monthly depreciation, the accumulated value should pick the results from monthly depreciation and add it to …  |
| | Hi. I'm confuse on how I will create my temporary table. Need some clarification here. I want to create a temporary table that will hold some column and values. And later on I would alter/update the table to add another column and data with respect to the existing columns. ammm... … Databases mysql |
| | I had two versions of SQLEXPRESS on my computer earlier ,now I have uninstalled 2012 SQLEXPRESS from my computer Now when I try to attach .MDF file made in 2012 version it gives me error. TITLE: Microsoft SQL Server Management Studio ------------------------------ Attach database failed for Server 'My-PC\SQLEXPRESS'. (Microsoft.SqlServer.Smo) For … Databases mssql pay-per-click |
 | I need help on building a mysql query. I have 2 tables : list and type. List : id_list, name Type : id_type, id_list, name The id_list column in table Type is a reference for id_list in the table List. My HTML [main.php] : <head> <script src="//ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script> <script type="text/javascript"> function … Databases javascript-jquery mysql php |
The End.