Hi,
I am designing a conference management system, I have not determined which database to use and would desperately like to know what are the main advantages/disadvantages to implmenting s...
Hello,
I have a PBF file and was wondering which software I should use to open it? I've tried using Excel but it's having trouble opening the file. Any suggestions?
Thanks
I am currently retrieving the date time in one of the text box in a form
Dim checkDate As Date
checkDate = Me.DTTXT
the checkdate is in dd/mm/yyyy hh:mm:ss format. I want to convert i...
hi all,
i am using the below query to do a fast export in teradata
sel
CAST((b.id (FORMAT 'zzzzzzzzzzzzv')) AS CHAR(12)),CAST('|' as char(1)),
from
customer b
here the column ...
Hi,
I am using "DB2 v8.1.14.292" version of DB2 on windows XP SP2 machine.
While starting the m/c, I m getting the SQL6031N error:
Error in db2nodes.cfg file at line no "" reason code "...
Hi There,
I had asked a question related to something like this before but never got to the bottom of it. I am hoping someone can help me this time.
I have a text field with in this field...
Hi all,
Hopefully this is a straightforward question.
I need to execute "DBCC CHECKDB" on my database, but to do so, I must be in single-user mode.
I know how to start the database in...
How do I trim out the Person's name in the following field lets say the field is called Ref and I want to trim out the person's name. Trying to get a generic trim just in case there is someth...
hi there
I have the following query and its output:
1 SELECT A.NAME,COUNT(COURSE_ID)
2 FROM SUBJECT_AREA A, COURSE
3 WHERE A.SUBJECT_AREA_ID =COURSE.SUBJECT_AREA_ID
4* GROU...
Hello Gurus!
I am working with an application that updates a FACT table in an oracle schema. I want to add a trigger to that FACT table that executes a stored procedure that moves the data f...
in insert statement how do i append a carriage return to a field. (at the end)
I have two almost similiar tables in sql server. I want to run a query to compare those two tables and to find out those rows that are not common. here are the columns for the two tables
Ta...
there are 38 of thses files on my c drive alone. can they be safely deleted, esp teh one in the temp folders?
It seems that office 2007 (excel 2007) can no longer save files to dbase. I had been using this facility to create the field headers for dbase files. Can you suggest some workarounds? A utilit...
Grettings..
I think here comes a tough one (at last for me). I have a tables with Member_ID as a primary key:
Members (Member_ID, Full_name, Ph_No , Bill to pay)
and there are 3 tables c...
Hi,
I wanted to know the major differences between MySQL and ORACLE.
Thanks in advance
Hi,
I want to combine two columns in a sql statement with 'AS' but am unsure how to do it with SQL Server. For example, combine a LastName field with a FirstName field 'AS' Fullname. Help?
I am trying to do an update query in SQL 2k that updates a name field and removes only the pattern of space middle initial space. I do not want it to strip out any additional names in the fiel...
How many records can a Microsoft Access 2003 database handle?
I know there is a 'practical' limit of 2Gb fize size, but for a 4 field per record database can anyone tell me a rough number? ...
I have the following query:
select a.file_job, Cntr=count(cont_num), CntrOut=count(date_out), CntrIn=count(date_in), Status=''
from cargodetailcontainer a join cargodetail b on a.file_jo...
Hello,
I need to insert miliiseconds in a date field in oracle 9i . I use the following query
UPDATE MSGDB SET CUSTOM25=to_date('2003111212110000','YYYYMMDDHHMISSSS') WHERE MSGDB_ID = 2...
I,
I have written this simple SP to pass one value to the SP and return three values.
The procedure is as below:
create or replace procedure get_count_of_dnis1
(
dnis_in_out in out varc...
I have a number of programs that will not connect to the internet. I have a new computer running Win2K Pro, no firewall and a dial-up internet connection. My filesharing programs, Kazaalite (w...
I have a database that sends an automatic email. Everything worked fine but I had to create a new database and reload the tables. I lost one reference that I had to select again in VB in doi...
Hi I am trying to spool out to a CSV file using SQL Plus. The select statement I am using has paramaters &1 and &2. I have turned Echo Off but am still getting the actual SQL statements in my ...
