7,494 Archived Topics
Remove Filter  | |
| | Hi guys! I've never used SQL Server before and I don't want to fall at the first hurdle. SQL Server is installed and connected to the server but how do I go about actually creating the database? I am developing a web based database using dreamweaver and asp.net. Do I … Databases asp asp.net mssql sql visual-studio web-server |
| | I have a table on an offline database having let say 2000 rows and same table on an online database with let say 3000 rows. Now I want to copy just those records (1000) from online database that are not in the offline database table. Also, both tables have same …  |
| | i wanna put 1st row in action with 2nd row... then 2nd with 3rd and go on... i did this three records i got correct result but when i add more records... everything is involved... i tried many different combinations but no success.. i want to solve this in sql … |
| | I posted a similar question in MySQL section before but i think this one might be more general/easier to understand (hopefully): I'm doing a database (in MySQL) of different plants which is gonna store various (somewhat detailed) information about them. Here's a sample of two tables: Families (Plant Family) [code] … Databases database-design |
| | Hi Guys, I am developing a Web based database for a company for my year work placement for university. As I am still a student I am still learning and finding this difficult. I am looking at designing a login page using ASP, the code I have is:- [I]<%= sErrorMessage … Databases asp |
| | Hi All I am trying to connect to my database from the front end in VB.NET 2003, the connection strings that i have tried are not working at present. I have VB.NET 2003 program from last year but that was using access as the back end and VB.NET 2003 as …  |
| | Just a question on database setup and application. If I have one database, with multiple tables within it, at what point does it become prohibitive. 50 tables? 100 tables? Is it a memory thing? How can I check? Thanks, -JP |
| | hey everyone, i have a problem with normalising my set of data...i am sure it would be easy for alot of you, its jus right now i have a mental block anyhow its for a yearbook publishing company. the data set is as follows: schoolCode, schoolName, address, city, state, postalcode, … Databases publishing |
| | Hi All, I work for a company where i have informations of all parts and their part numbers in the Database. But the problem is whenever someone else uses the database for getting the part numbers for the items they can easily change the information on the database without my … Databases |
| | Using FileMaker Pro 8 I have a table whit a column for dates, like showing below. dates Mon, Sept 10, 2007 Wed, Sept 12, 2007 Wed, Sept 19, 2007 Mon, Oct 8, 2007 Mon, Oct 15, 2007 I want a field(s) to show all those records like this Sept 10, … Databases microsoft-access |
 | Hi All, I am New in MySQL. I Want to Create a Database in MySQL. I am Using MySQL5.0 & Write This Sentex for Creating Database :- CREATE DATABASE db_name; But When I Use This Sentex Create Database With Single db.opt File. & I run this Database on Server Message … Databases mysql |
| | I have script that is almost done, I just need help with one more thing. I'll describe the relevant structure the best I can, then explain what I need. TABLE carlot FIELDS trackpt, id TABLE cars FIELD userid, carid TABLE grpusers FIELD id Field id from table carlot = field … |
| | TITLE: Connect to Database Engine ------------------------------ Cannot connect to CHESF-HIMRIO\SQLEXPRESS. ------------------------------ ADDITIONAL INFORMATION: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. …  |
| | Hi guys, I'm very new to MySQL -- so, your help is very much appreciated. I have a table that has 50 fields. 2 of the fields are primary (named: item_number and catalog_year). There are about 1200 different unique items on this table. Now, what I basically need to update … Databases mysql |
| | Hey, I am creating a recruitment database and will be using a managed hosted service. I have read MSSQL is more expensive, but does this matter if I am paying someone else for hosting? The site is going to be in .NET, and I initially was planning to use MySQL, … |
 | Hi there I"m building a page that displays events for example: Event heading 05 June 2007 Event Description Another Event 19 June 2008 Event Description What I'd like to know is how do I sort the events by date in the format shown above. At the moment I have a … Databases mysql |
| | Hi all, in my website there are ftp-uploaded images (about 3000) in a folder called IMAGE. What I want to do is somehow get the image file names inserted in to my database so, I can see image file names in a pull down menu selection when I insert records … |
| | Hello, I am trying to write a single query to run a report. I have it working for a single farm, but I need it to work for a list of farms. I am having trouble linking the farm number for the inner query to the farm number for the … Databases mssql |
| | Hi guys! I am developing a web based database for a company for my year work placement for university. As I'm still a student I am still learning so I am not 100% on what i am doing. I was wondering if someone could provide me with some help?...please! :) … Databases mssql |
| | I want to insert 2 table at the same time . There are relationship between them .My tables are: Topic : topicId, topicDate,topicInformation Reply: replyId,topicId, replyInformation Databases mssql |
| | hi, i'm a final year engg. student of MU. I require a mini project based on SQL related to real system scenarios. PLZ HELP!!!!!! Databases oracle |
| | Ok, i have a database where i'm storing information on plants and in one of the tables is a plants table: here's the first few fields in the table plants: [code] plant_id, family_id, genus_id, species_id, auth1, auth2, ... [/code] plant_id is the pk, family_id, genus_id, species_id are foreign keys. soon … Databases mysql |
 | Hi all, I hope everyone is well. :) Ok, I don't know how to explain this properly, so I'll just struggle along & if you need anything clarified, please ask. First, I'd like a quote from only very experienced MySQL/PHP programmers on how much this appl. will cost to build. … Databases mysql php web-server |
| | I want to know how to copy the mysql database on my development PC to mysql server on my production PC. Please, anyone who knows how to go about this should help me. Thanks! JNORA Databases mysql |
| | I've been tring unsuccessfully to find information on what each language, C and PHP, have to offer in terms of working with MySQL. Just wondering if anyone out there has preference for one or the other and why. I understand that PHP is supposed to have alot of built-in functionality … |
| | How is the best way to back up Outlook 2003 Contacts. I want an external back up that I can transfer contacts to another computer and do it daily if need be. Databases microsoft-access |
| | Hi All, I'm developing an application using VB 6.0 & using MS Access 2000 as backend. How many records can I store in a table? Is there any such limit? Databases microsoft-access |
| | I am using oracle query in that four fields are number. I am subtracting that field such as (field1 - field2 -field3 - field4) as DNF Actually I am creating query in view. While creating this view the last field DNF is created as varchar2(40) automatically. I am using this … Databases oracle |
| | [COLOR=midnightblue] HI all, I am very new to SQL server and have been working my way through a book to learn ASP.Net v2 and SQL by building a e-commerce site. There are 3 stored procedures which are used to implement paging from retrieving products from the catalog, which are either … |
| | Hi, I'm designing a database for a company that retails computer products, phones, faxes and so on. As you can imagine, there are a number of different types of products, eg. hard drives, CPUs, routers, optical drives and so on. One of the requirements is that for each category there … |
| | i have the following query SELECT C.FIELD6 ,C.FIELD2,C.TRANSACTIONNO FROM ipfroutine_deduction a,Servicemaster B,INPATIENTBILLALLDETAILS C, Departments D,INPATIENTBILLS E WHERE a.ipftestcd=b.code AND C.BILLNO=E.BILLNO and trim(a.ipftestname)=trim(b.childname) AND TRIM(B.childname)=TRIM(C.FIELD2) AND TRIM(A.IPFDEPTCD)=TRIM(C.DEPTCD) AND TRIM(C.DEPTDESCR)=TRIM(D.NAME) AND E.FROMDATE BETWEEN TRUNC(A.IPFFROMDATE) AND NVL(TRUNC(A.IPFTODATE),E.FROMDATE) AND C.BILLNO = 'D00024585' It's result as NO FIELD6 FIELD2 TRANSACTINO 1 220 CHG (HB TC … Databases oracle |
| | hi myself piyush me too has to design a project using VB and DBMS plz suggest me topics Databases oracle |
| | Hi all, Im trying to create a trigger but keep getting a syntax error. Basically the trigger must be created after a insert on table_1 and update another table's fields with 1 depending on what was inserted into table_1 ( apple, orange, banana, grape ) CREATE TRIGGER trigger_name AFTER INSERT … |
| | Ok this is what my table structure looks like: username varchar(20) eadd varchar(40) for email addresses bday varchar(4) everyone is posting mmdd emailques varchar(2) they answer yes or no I want my query statement to tell me what birthdays are today and as a bonus email them on their birthday. … Databases mysql |
| | My query is below. I need to evaulate each row returned (and provide a "label" - shown with an astrick) based on the values in the 3 date columns and I'm stumped as to how to do it. Here are my conditions and labels: Action_Dt = Effdt AND Action_Dt < … |
 | Hi, i am having a problem with indexing. In my database, one of my table have 3 foreign key references, All these fields are indexed by default. I need to create an index for a regular seach item. is there any problem regarding performance, if i combine the primary key … Databases mysql |
| | hye...im having difficulities to retrieve data from one table. i need to retrieve data from few columns and multiple rows in one table and display it the data. is there any way of doin it? urgent help need!! Databases mssql |
| | I can't find any DTS tool on MSSQL 2005 Express Edition Is there any tool that execute DTS tasks? I need to perform 2 tasks: - import a large Access file into MSSQL - deploy database to production environment Any help is welcome. []s Databases mssql  |
| | Customer: customerId, customerName Order: orderId,customerId,product, date, productDefinetion I want to display the order which is the latest order from the customer and I want to display all customer Name Example: customerName product productDefinetion John Video bla bla bla Maria ------ ----------- |
| | Hey Guys, can you suggest any Open Source Application Server for SOA deployments. Also, wondering, if our needs are somewhat lightweight, is there some lightweight open source Application Server you could Suggest. Databases mysql open-source |
| | Dear All, I have a [project] table which includes Project name,Startdate,EndDate,Location.and [SubContractor] table which includes id,subContractor_name. each project has one SubContractor at time and one SubContractor may have many projects at time. There are cases in which the first SubContractor leaves the project for some reasons and the company give … Databases database-design |
| | Iam working on a purchase managment system that manages the puchases and inventory of the company that sells pcs. i want to manage employees (pemant,consultants) , customers , supliers , business partners all will be the users in the application . what would be the right design of the database … Databases database-design  |
| | Hi there. I'm looking for a bit of advice. I have a lookup table (tlkOrganisations) which has only one field (apart from the ID) and it list orgnisations. I'm using this for a field within a form so that I can use it as a lookup combo. The advice I'm … Databases microsoft-access |
| | Hi guys! sorry if there is already a thread on this but i couldnt see one... I just want a little bit of help about the statement ON DELETE CASADE. I am designing the structures of my tables and I am not sure about using this statement. I know it … Databases |
 | Hi All I am trying to create 2 tables Table 1 with cust_id , username and password (Cust_id is primary key here) Table 2 wth cust_info that will store info for that cust........now i want to use this Cust_id as foreign key here in table2 but i am not able … Databases mysql |
| | Hi, I am a student on my year work placement and I have been asked to develop a web based database for a company. I think my design is ok but I am a bit confused in a part... The company wish to save emails in the database to and … Databases database-design email web-design |
| | Hi, I have been searching around for a few days and cannot find exactly what I looking for. Was hoping someone could point me in the right direction. Looking to query MYSQL with keyword. For each of the records or rows its finds based on match. Would like to retrieve … Databases mysql |
| | hi all, Very new this forum. i am using MSSQL 2005 and i want to create a backup script for a table [create and insert statements] without using mssql datapublishing wizard 2005. is it possible?? how can i do it Best Regard Databases mssql |
| | I have a Database which is dealing with a book library system. I have a table which has a has a field dealing with the ReturnDate of a book. I was wondering if it is possible to do a SELECT statement that would return the the fines due on an … Databases mysql |
| | Hi. Can anyone help me with this? If I have, for example, a MSSQL database named 'COUNTRIES' and an existing table in the database named 'COMPANIES', can anyone let me know how I can add an additional field name 'PEOPLE' with a string datatype (for example) to this existing table … |
The End.