7,494 Archived Topics
Remove Filter  | |
| | what is the required t-sql for getting all the child categories in a parent category? my table is like this : id | name | parentid Databases mssql |
| | Anyone know where I can get a free MySQL database so I can start the learning process for myself? I saw a post listed here for dbfree.net.. that post is old.. that takes you to IX Webhosting. I signed up for db4free.net but when I goto login it says "Loading" … Databases mysql web-browser  |
 | Hi i want to select the values from my table where a column must contains some value. So i wrote this Select * from RG_TAB where CMCode = 4 and CMCode = 5 This query not giving me any result but Select * from RG_TAB where CMCode = 4 Or … Databases oracle  |
 | Hi there I posted this problem in the php forum thinking the issue was something I had done wrong with my PHP but is now looking like a MySQL or possibly a technical computer error altogether: [url]http://www.daniweb.com/forums/thread108602.html[/url] Could someone please help me out. Databases mysql |
| | Hi guys, I am trying to find a solid optimization technique for my problem. I have two tables that grow quote large: [code] CREATE TABLE `mydb`.`xm_artist` ( `artist_id` int(10) unsigned NOT NULL auto_increment, `artist_name` varchar(255) NOT NULL, PRIMARY KEY (`artist_id`), UNIQUE KEY `index_artist_name` USING BTREE (`artist_name`), FULLTEXT KEY `fulltext_artist_name` (`artist_name`) … Databases mysql  |
| | Sorry if this has been posted before, but I'm in a bit of a dilemma of sorts. Also, if this sounds rather unclear, let me know, and I'll explain things further with a few photos. Before I begin, I came across this thread, mentioned at [url]http://www.daniweb.com/forums/thread105907.html[/url] ...this had something to … Databases |
| | |
| | i just wanna ask if it if possible to make columns n ms access and how... because i am making a personal data sheet thanks in advance more powers and God Bless You all Databases microsoft-access  |
| | hi i am learning to work with mysql and c. i want to select a particular row from database which must be equal to a variable and the variable should be given by user.the program is in c where i use c api to connect sql database. how to join …  |
| | I have question about TRIGGERS. I have (4 example) VEHICLE_TABLE with VEHICLE_TYPE column and CAR_TABLE and TRUCK_TABLE also. I need TRIGGER for INSERT/UPDATE/DELETE who well read value of VEHICLE_TYPE column in VEHICLE_TABLE and if value of VEHICLE_TYPE is CAR he will execute INSERT/UPDATE/DELETE on CAR_TABLE and if value of VEHICLE_TYPE … Databases mssql |
| | Hello guys, I need some help hope you all can help me with this. So i have 12 little (I don't know what to call them but let's say) stores which are selling the same products (at this time 12). Like hot dogs, cola, gum and other stuff. Every day … Databases database-design |
 | sorry if this a very newbie question but what wrong with my code : [CODE=MSSQL]select TBIn.NoTbin,TBIn.IdBrg, Barang.NameBrg,TBIn.SupCode,Supplier.SupName from TBIn,Barang,Supplier where TBIn.SupCode=Supplier.SupCode and TBIn.IdBrg=Barang.IdBrg and TBIn.IdBrg = B002[/CODE] Please Help, Best regards... Databases mssql  |
| | I have a database with let's say two tables as follows: [U] Products Table[/U] ProductID | ProductName and [U]Widgets Table[/U] WidgetID | ProductID (Foreign Key) | Position Now how do I set it up if I want a variable number of widgets that attach to a product. But I want … Databases |
 | |
| | I've got two tables - members and sponsor, their simplified structure below. members: id_num program_id sponsor_program_id sponsor: id_num sponsor Some of the members in members table are sponsors. I need to update the field sponsor_program_id in all records in members table with their sponsors program_id field. Sponsor table tells me … |
| | I have developed an access database for my company and want this to be available to multiple users remotely from different offices. I have been told that i need to migrate to MS SQL Server. Is this the case?? If so how do i do it? If not what do … Databases microsoft-access sql |
| | Hi, I'm a bit stuck here. I have a table called STM_COMM and it contains following fields: id, member_id, email_addr, tel_nr, fax_nr A member can have multiple email addresses, telephone numbers and faxnumbers. so we could have something like this: id member_id email_addr tel_nr fax_nr ---------------------------------------------------------------- 1 5 info@test.com 2 … Databases mssql |
| | Hello Dear Experts! I need Oracle and EnterpriseDB comparison in detail. kindly help me. Databases oracle |
| | Hello- I have these two tables: [code] CREATE TABLE ampref ( ampref_id serial NOT NULL, amp_id integer NOT NULL, code character varying(255) NOT NULL, description text ); CREATE TABLE amp ( amp_id serial NOT NULL, name character varying(255) NOT NULL, description character varying(255), url character varying(255) ); [/code] ...and I'm … Databases mysql  |
| | Hi, this is my first post. I have a website [URL=http://www.psychopanic.com]www.psychopanic.com[/URL] and theres an IP address that I want banned from accessing my site (203.213.0.10). Does anyone here know how to make a MsSQL script that can ban ip addresses? my webhosting Plesk control panel only lets me use MsSQL. … Databases first-post mssql |
| | Hi folks This will be my first ask for help here;) I'm working on a database at the moment and have exhausted my resources on this one. I have a report with an underlying muti-table query. The report uses an input box to set the date criteria rather than Parameter … Databases microsoft-access |
| | there a way to get this info about my tables in a text file or anything that can be copy paste . i have many tables so i cant write them one by one? Properties DateCreated: 08/05/2007 11:38:58 PM DefaultView: Datasheet GUID: {guid {A79F9FC7-D630- LastUpdated: 09/05/2007 12:18:31 AM 47FB-A227-EB5202999268}} NameMap: … Databases microsoft-access  |
| | Goodday all, Just tried to install MSDE, no sooner then i click the intall icon, i get this message "A strong SA password is required for security reasons. Please use SAPWD switch to supply the same. Refer to readme for more details. Setup will now exit." Now i took a … Databases microsoft microsoft-access |
| | i want sample code with Html with Ms Access.....i want urgently,, Databases html-css microsoft-access |
| | |
| | Is there a way to open the main access switchboard in windows without showing the access program? as a usable Data Base. Databases microsoft-access |
| | Okay, this is the situation. We are trying to set up a database where we input individuals for their personnel evaluations. We created a button in the form window and linked it to a macro that updates the "Date Due" block based on the date in the "Date Completed" block … Databases microsoft-access visual-basic |
| | I am not a developer or especially knowledgeable in MS SQL, but I am the person responsible for creating special queries for my companies SQL Database. I have a query that is selecting customer names, addresses, product ordered and e-mail addresses. I am want to select only those customers with … Databases mssql |
| | Hi all, This is my first time... and i'm not an sql guy by any means, but i can insert, update, blah blah... I have a question to ask, i have a table that has UniqueInt | Date1 | int1 | Date2 | varchar 1 I have duplicate records that … |
| | How do you write a store procedure to meet the following conditions: PROXIMITY SERACH PROCEDURE COMPANY table PK company_id int company_name varchar(100) premise varchar(10) street varchar(30) town varchar(100) postcode char(7) x_loc int y_loc int COMPANY_KEYWORD table PK, FK1 company_id int PK keyword varchar(100) The data above shows an extract of … Databases database-design mssql |
| | Hi, I'm trying get some summary results from two related tables. I'm looking to find the most efficient way to return this data in one result set. The tables can be summed up as follows: [code] MainTable MainID INT, Description VARCHAR(50) Eg: MainID Description 1 John 2 Adam 3 Fred … Databases mssql  |
| | How do I create a single sql statement that will insert a row into a data table and return the row number back for processing? I tried to use the scope_identity method and find out it works well within a stored procedure environment. If anybody out there have another method, … |
| | Hey I've set up a maintenance plan to backup databases daily and noticed the following error in last night's backup - Database 'BizTalkEDIDb' is not valid to be included in the maintenance plan. Has anyone seen this error before or have any idea what it could mean? Thanks in advance. … Databases mssql |
| | |
| | I've got a Perl script that lets a client of mine dump and restore his inventory database. It has worked fine for years, only I recently noticed strange file results. Instead of dumping the data to the file, I found this (I've munged the db name): -- MySQL dump 10.10 … Databases client-server mysql perl |
 | I am using SQL Server 2005 to run a stored procedure to update, delete, or insert depending on some conditions. The problem is that it gives the following error: Msg 4104, Level 16, State 1, Line 49 The multi-part identifier "PART.ID" could not be bound. I have it inserting some … Databases mssql |
| | Hello I got a nice one. I have 2 MS SQL 2000 databases on the same server both are almost alike. Both have an items table with the field searchcode I want to copy the searchcode from db1 table1 to db2 table1. So something like this: [CODE] use [db1] select … Databases mssql |
| | hi my name is Anna and i have got this problem i am trying to practice sql queries using following database relational modell i know most simple ones but with these ones i got trouble it is about book lybrarry database using oracle. The primary keys are underlined. The foreign … Databases mathematics oracle sql |
| | Using PHP on my registration page to register users on my site. Everything seems to be working properly from a PHP perspective. It even tells the user that they've been added. But when I view the table it only has one record which is the one that I created when … Databases mysql  |
| | I'm working with SQL Server 2005 on a stored procedure, but it appears to be going through both parts of the following statement, and not skipping the second half if it is supposed to. Basically it should update the row if there is data there, and remove the row if … Databases mssql |
| | I am creating a database from scratch for a scrap metal company in the uk, i have limited experience in MSexcel and have created some sort of database, however i reckon their are loads better software packages out there that are simple to use for a novice like me - … Databases |
| | Hello! I have two tables in an MS SQL database that I'm trying to join and display through PHP. My connection is fine and I've done it many times before, so don't worry this isn't a PHP problem. It's a my-query-won't-finish-executing problem. Table A: (about 2 million entries) id | … |
| | Hello, there this is my first post and I´m desperate seeking for help, I have almost not knowledge of SQL as it is not my usual work. However, suddenly it has converted in mine....Hopefully I will got help in here. Well the issue is that our database manager has resigned … Databases encryption mssql |
| | can anybody tell me abt the difference b/w sql server 2000 and 2005 |
| | I am in the early stages of writing a program in VB 2005 that deals with taking a test. I need to create an ERD for the project that deals with taking tests and storing the results. All users, admins, instructors, tests, questions, answers, and results will be stored in … Databases database-design |
| | but i hope someone can point me in the right direction. here's the story 2 pc's, one upstairs with database one downstairs used to access and make changes to. This was working no problem for months. Then the downstairs pc needed a new AGP video card, easy install no configuration … Databases microsoft-access mssql sql video video-card  |
| | [B][B]hi every body i'm new to MS SQL and i want to learn it if any body knows good source or web sites about sql server 2000, i'll appreciate if he lets me know thanx for your help, everunloaded, bye[/B][/B] Databases mssql sql web-server |
| | I am a network guy and not at all a programmer, but as I work for a small unit in a big company I have been given duties for a specific job and can not complete. I am trying to write code for a crystal report to do to theings. … Databases |
| | I have a static page/site that I want visitors to be able to personlize, so that everytime they return they will find their own unique settings, links, personal information etc. I do not want them to have to login upon return. I have no idea what type of programming I … Databases |
| | I am working on a product reviews site using php and mysql, and have a table set up for product data, as well as review data. I am trying to get a list of top rated products within the last 24 hours to show up on the front page. This … Databases data-structure mysql |
The End.