I have drawn up a table for my web application I will be making that the users will be able to pull up troubleshooting templates based on the filters they select for example category - hardwar...
I am getting the error message below (in the event viewer) and a the application I get error prjTagGenerator (connection timed out make sure your data base is turned on) then when I clcik ok i...
For multiple column MyISAM indexes where the combined index value does NOT have to be unique, does MySQL maintain one entry per table row in the index, or does it have one entry per index valu...
Hi All,
Is there any script to provide the information about list of all objects (tables, sp, views, funtions, trigges) existed in a database.
Thanks in advance
Hello,
I need to diplay a field called CurrTitle in the CC_Curriculum Table and also GradeName in the CC_Grades Table. Please see the current Stored Procedure that i'm currently using.
...
I have the table below and it's susceptible to update anomalies, what is an example of an insertion, deletion, and modify anomalies of the table?
About the delete, I was thinking that if I ...
My form has four tabs and I want to control navagation between these tabs and make certain the data in tab 1 has been entered before the user can choose tab 3 - or - initialize fields on the t...
I have a client who is being serviced both by us and another firm. They have a 12GB SQL database. The have one group that wants to slice the data in any one of a number of way and another grou...
Hi,
Can anyone please tell me how to keep information typed into fields in a form once the page is refreshed? For example, if the user types their name and address into the form and they p...
Hi eperts,
I'm trying to update a date in one dbase table from another linked dbase table using local sql.
The code I'm using is
update contact2 c2
set c2.ulastsale = ld.ONDATE
wher...
Hello,
We use a product called AMS 360 written by Vertefore. The product works well, except for reporting or data mining purposes. I was wondering if someone could explain my options to me ...
How can I get the day and the month to always display in a two digit format. i.e 09 instead of 9 for the current month?
string dbDateStamp = DateTime.Now.Year.ToString() + DateTime.Now.Month....
I have been asked to create reports off of an exisitng Accounting db. The issue is one of the columns is named "Check". I am using Cognos and hitting the table VIA a Pass-Through query. I am w...
Hi,
I have the data.odb database created via the OpenOffice.org Base application. I need to read the data from my C++ code. How can I do that on Microsoft Windows OS? Is there any OLE DB p...
Hi i am doing a Website Project where i need to store the regional language in the database. My Default Collation is
latin1_swedish_ci
what should i keep it so that it should recogn...
Please, let me now if there are any features in D2K(Developer 2006) to get the out put from oracle database into Excel Sheet!!!
I would like to convert the format of a Date field in sql. Currently the field (Inv_Date) holds a value such as this "4/6/2006 " I would like this to be shown in the query result as 06-Apr-200...
I have two tables - each relating to start/stop dates for a category:
Project table
Project Worker Start Stop
Prima Chuck 1/1/2009 1/5/2009
Beta Chuck ...
I have Customer, Employee, and Hotel entities.
Each of these entities can have several phone numbers. For example, employee can have home, cell, business phone numbers. Hotel can have custo...
Hi,
The 2 phase commit is a blocking protocol. If coordinator fails and participants are in de READY state they keep waiting.
Why is the 3 phase commit non blocking by adding the PRE-CO...
Hello,
Does any one know the record limitations in an Access and SQL database.
My projection is that i'll have 500,000 - 1,000,000 records. Any recommendations on something low-maintanc...
hi
i have a table userselectedsegment which has couple of columns i need to update from another table the following items i need to update
VideoFilename
GameID
CREATE TABLE [dbo].[UserSe...
I have a table called ctc_rec, it has many rows, but I need to pull out the same field 'cmpl_date' but give it a name based on the resrc field.
So how do I make this into one query:
select...
Hi Gurus,
In one of the column in my table the date format is in the form '20091027' I am using the SQL Server Database. I want the output in the form 10-27-2009. The output should only be ...
Using MS Access 2003, I am trying to bring data in one field from Table 2 into matching records in Table 1. I'm unable to figure out how to get an update query to do this. I have identical ...
