7,494 Archived Topics
Remove Filter  | |
| | I'm developing a web page for a friend that allows participants of a sports event to "claim" a slot in a 24 hour tennis marathon. The marathon has room for 24 x 4 participants. My idea was to have a table with the columns "hour" [0-23], "time" and "name", and … Databases database-design web-design |
| | Hey, I am Sita,i want to know some basic DBMS concepts . What is a DBMs? What is an RDBMS? Anybody can help me?? Databases  |
| | I want to display the columns in to rows format as below: eg: [U] col 1 [/U] [U]clo 2 [/U] yes No I want this to display as: [U]Column name[/U] yes no The Code which i used as below: [code=sql]set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO create PROCEDURE [dbo].[Vista_Capable] AS … Databases mssql  |
| | Hi all, Is it possible to insert a SQL statement where I specify the time, and not the date. I do need the date, but I want it to be the current date when I run the insert statement. The time got to be fixed. For example, Insert into xxx …  |
| | I request the assistance I work on the library database, But I have problem on the erd and relationship between entity ,if any one can help me I am grateful to him . this my project if any one can add some entity and the erd please: The system contains … Databases |
| | I'm using this piece of code to get the number of search results. However it says- Incorrect syntax near ')' (the very last ')' ) [CODE] SELECT COUNT(*) FROM (SELECT ID, ProductDescription FROM Products WHERE ProductDescription LIKE '%tech%') [/CODE] The inner select works fine and gives correct results, so I … |
 | Good Day all it is Probably a long day, i cant think Straight now. i have a table that looks like this [CODE] Nodeid Parent Description Type Curr ========================================================================================== 89 NULL Compulsory 1 10 90 89 B1052 3 10 2820 89 One of 2 10 [COLOR="red"] 4113 89 B1061 3 … Databases mssql |
| | hi, can any one tell me how to i use my sql sever's databse itno ms sql 2008 server. I tried to to do dat with the help of mysql backup file & execute it on ms sql server, but there are some syntax related problems. please help me. thanks … |
| | Greetings! I am hoping someone can help me with a MS SQL query/view problem. I am creating a "name my new baby" website where parents can upload a picture of their child and have users cast votes for a good name. Users will see the child's photo and they will … |
| | Hi, Basically what im looking to implement is a function where a user performs a search on my site, and is presented with the results and an option to be emailed similar items in future. I have all the search stuff done, but have no idea where to start on … |
| | How can I create a SQL Script using MySql? I already created a database and tables. I populated the tables and wrote queries to solve the questions in my homework. But the professor want me to submit the SQL script. Can anyone help me? |
| | I need a bit of help with a mysql join query. I have tried and tried and keep getting unhelpful errors. I have two mysql tables: friends: friend1 INT friend2 INT members: member_id INT name varchar lname varchar Basically I want to loop through friends and find all records where … Databases mysql |
| | I am fairly new to mysql and wanted to practice making a database and tables. As well as filling the tables with made up data and then practicing queries. I wanted to emulate a real life database project. So I decided to make a database for a Car Dealership. the … Databases data-structure |
| | hello , (begginer of SQL) i have to make one pro. in which i have to use trigger which will fire before inserting into table and convert the name into upper case but i don't what is the prob. with the code pls provide ur suggetion my table attributes are … Databases oracle |
| | I have an idea of the design but I want to know if it wont impact performance. I have a student form consisting of Qu like: - Do you have internet access - Relationship - Do you want to pay by cheque, credit card + other options - etc So … Databases database-design |
| | I want to set a password to [B]phpmyadmin interface[/B] in WAMP.. How can I do that?? I jst want to make sure that no one will change my databases using Phpmyadmin GUI ..() mysql console is ok..... thankx in advance.. |
| | Hi I would like to create a database to classify and control all the photos that I have stored in my computer. It is clear that I need one table PHOTOS with attributes of ID, name, camera and date. Second table would be DATA, including aperture, ISO, fstop, focal length, … Databases database-design |
| | Hi, First of all, I'm no database expert. See me as managing a project where this problem occurs. We are building a system that will enable us to roll out Windows Patches automatically to all Windows systems we manage. We use WSUS on SQL Server 2005/SQL Express. The application will … |
| | I want to find the capacity of my data fields....how can i calculate capacity of varchar(10) or int(15)...???? (in kilobytes s or megabytes s) please help..t hankx in advance. Databases mysql |
| | hi I have got a table for "internet access" with user ID, it has 3 columns user ID, starttime and endtime, i want to make another column which will show how many mins or hours that user was logged in to the internet and also add the total time if … Databases oracle |
| | I am working on an Oracle homework assignment, working in shell, trying to query a tricky display question my professor has asked for. I will show both tables, and what I have to execute. [code] SQL> describe orderline Name Null? Type ----------------------------------------- -------- ---------------------------- LINENUM NOT NULL NUMBER(3) ORDERNUM NOT … |
| | Hi I am sitting with an flat db file, and need it converted to 3NF Example: ProductID Published Title Authors 1 2000 Car Mech. Bill Meyer, Peter Daniels I have split this structure in 3 tables: Book Author Author_Book In Book I have the following fields: (PrimaryKey)ProductID, Producttitle, Published. In … Databases |
| | Below code is in my DB file. If I enter a card no in first record, for Others card no will be automatically comming. but for the other "Test " I want to show the record no automatically. I was coded below. but it's not working. Pls help me. Thank … Databases |
| | Hi, What would be the best way to have film found from a database of films using a number drop down menus and maybe a search bar? The results would be displayed in a list. Wht would be the best way to build this? Thanks Dan Databases |
| | |
| | I have been given a task to normalise a set of attributes, I have started with 0 normal form (the attributes) and have attempted to normalise them. Quite frankly im useless when it comes to normalising and I was hoping someone could have a look at my attempt and explain … Databases |
| | Hi, I have 2 tables that I have made using sql create table which seem to work ok until I try to insert data into the 2nd table then it throws a: didn't add 1 record due to key violations. When I use the design wizard and do exactly the … Databases mssql |
| | hey; I'm creating a image database. I want each user to register, login and be able to upload images. I however, do not know if each user needs to have their own database for images to be stored in or if I can grab the image via foreign ids from … |
| | I have access 2003 and sombody send me an access 2007 db . how can I open it? Databases microsoft-access |
| | Hi all I am in the process of designing a database structure for a very common use: to store client data such as names, addresses, company information, etc. I have been reading up a lot efficient database design and am trying to normalise to 3NF. As I am new to … Databases data-structure database-design linked-list |
 | Hi Everybody.. I installed wamp server and Mysql services doesn't start. I've found on Google Search. and nothing to solve my problem. Can anyone help me? Thanks.. Databases mysql |
| | Hello, We have a number of small access 2003 databases. We will be upgrading to access 2007 and there will be a period when some of us are 2003 and the remainder 2007. Is it going to be possible to use access under both 2003 and 2007 simultaneously? Thanks in … Databases microsoft-access |
 | Hello, I have an access table where I have to import a csv file. I have a very simple code in the Click _ Event Sub. However it seems the code is ok, file gets imported but I get a separate table with errors in import. In that table two … Databases database-design microsoft-access |
| | Hi to all , I am developing website in asp.net2.0 using VB. I wrote sored procedure, [code] ALTER PROCEDURE SELECTSC ( @cid INT ) AS BEGIN SELECT sc FROM collage_detail WHERE c_id=@cid END /* SET NOCOUNT ON */ RETURN [/code] and in vb I wrote on button click, [code=VB] cmd.CommandType … Databases mssql |
| | I stored two time values in mysql data as 'starttime' & 'endtime'. I have another column to store the' duration '(which will contain 'endtime-starttime') Is there a way to add values to ' duration ' automatically when I insert values to 'start time' & 'end time'. I use WAMP ..I … Databases mysql  |
| | Hi, I'm having trouble with writing this statement as an INSERT function instead of UPDATE. [CODE=php] $sql = " UPDATE tbl_category SET " . ($cat_parent_id == 0 ? "sub_cat_name = '$name'," : "cat_name = '$name',") . "cat_description = '$description', cat_image = $catImage WHERE cat_id = $catId";[/CODE] Sorry if this is … Databases mysql |
| | hi to all, this might be very simple, but i don;t know how to get correct output, someone help me to complete it... [B]1st i need to get result from this query[/B] [CODE]$sql="SELECT * FROM $tbl1_name WHERE sex='$show_all'"; $result=mysql_query($sql); [/CODE] this'll result either all the boys or all the girls; … Databases mysql |
| | I need to query a database of application titles and count the instances of each title. I've already got a list<string> of distinct values from a previous query, and now I need to count how many times each value occurs. I'm not sure if the query is correct, or how … Databases mssql |
 | As the title suggests, I'm having trouble sorting the results of a union statement. I'm trying to sort the results by date descending and it's coming out ascending. [CODE=mysql] (SELECT a, b, c, d, e, f, date FROM table1 WHERE a=10 AND b=1) UNION (SELECT a, b, c, d, e, … Databases mysql |
| | Hi, i have created a window service with multithreading, but getting many deadlocks on sql in one Stored procedure when i start this service,and after that service does not do anything but in idle mode. the details of exception is below. Error :Wednesday, September 23, 2009 2:22:58 AM Method:UPD_CrawlerLastUrl 1. … Databases mssql multithreading sql |
| | Guys, I need your help as I really can't seem to start on this query.I seem to not be able to come up with any logic. I have to create a query for a table. I have two tables in my DB . First one is a book table which … Databases mssql |
| | hi guys, done heaps of googling and everything leads me to two outcomes. 1. You can't do it 2. You can do it this way [code] INSERT INTO User(userEmailAddress, userFirstName,userLastName,userStatus,userNickName,userMifrenzPassword,userEmailPassword,userDOB) SELECT 'overthehill@gmail.com','Ben','Hill','U','benny','milk','soccer','20-10-2000' UNION ALL SELECT 'smithy@gmail.com','Tony','Smith','A','smithy','bread','rugby','20-11-1976' UNION ALL SELECT 'hotpants@gmail.com','Sarah','Jane','U','hotty','toast','netball','15-1-2000' UNION ALL SELECT 'traci@gmail.com','Traci','Hill','U','raisins','coffee','hockey','20-10-2000' UNION ALL SELECT 'lol@gmail.com','Ben','Johns','U','stubby','jam','rowing','10-2-2001' UNION ALL … |
| | hello, I'm trying to create a database in SQL Server management Studio for a project. I have created a tabel named Employee and I have 14 columns. I need to set the firts column (Emp_ID) as Primary Key (accomplished) and then generate a unique number for each Emp_ID that I … Databases mysql web-server |
| | I am creating two tables with names group,phone group caontains id,name,place,phone numbers phone contains id,phone numbers my query is that phone table should accept id and phone numbers that matches group table(id and phone numbers) can one please help me . Databases mysql |
| | Hey Everyone, So after weeks of torture, this things is near completion. We're using SSRS to display the report on the .NET side. However, I'm piecing together the last bits of the SQL query. So, I have three tables. One has names of all these buildings, one has contains reason_codes, … Databases mssql |
| | i am constantly receiving a 'failure audit' error 18456 state 14...login failed for user 'sa' on my sql 2005 server. this is occurring every 5 minutes. Can someone give me a direction on where to start? I have checked several forums on the web, but none seem to lead me … Databases mssql sql web-server |
| | Was just wondering if anyone here is an Access master have this code that I want too add a CHECK too but keeps on throwing a syntax error [code] CREATE TABLE Email ( userEmailAddress memo not null, timeDate datetime not null, contactEmailAddress memo not null, emailBoxType text(6) not null, readStatus … Databases mssql |
| | Hello everyone =) I'm a Java programmer who wants to do work with databases. MySQL seems to be a popular choice, but I don't know where to start. I messed around with Derby, but I didn't really understand what was going on. If anyone could point me in the direction … |
| | I use mysql to store some time values (infact 2 at a time) Startime & end time.... in two columns. I have another column called duration which stores the diffrerce of the above two time values... I want to fill that third column(duration) when I insert the values to the … Databases mysql |
| | Hi! I am a student and I am working on database that concerns customer-order-product relationship. When designing it I encountered an issue that I do not really know how to solve it in the way it seems reasonable and obeys Normalization process. I would appreciate for any assistance. Description of … Databases database-design |
The End.