Hi,
I have a customer table, it has one DATETIME field called "REGISTERDATE".
I want to select all data which has REGISTERDATE before March 31, 2005.
So, REGISTERDATE = April 1, 2005 ...
I have a Business Objects *.REP file with multiple queries I need to look at. The problem is I don't have Business Objects. Is there a viewer, or some other method whereby I could view the *...
What is the difference between oracle clause "Exists" and "in "
Hi!
I have got PostgreSQL installed on windows XP, seems to be working fine. I have earlier installed XAMPP (Apache,PHP,MySQL install) so I can run my scripts for testing locally. However I...
Hello,
please give the final year project ideas which is related to database, mobile technologies..
Note: Please don't give the research ideas.. and also don't give those ideas which are...
experts, i'm in need of urgent help
users are getting this error when connecting to the database
ORA-00257: Archiver error. Connect internal only, until freed
there is plenty of room on b...
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...
I need to be able to determine the percent of growth or decline from one year to the next. I have a group based on year and a summary field for the figure that I am totaling. How do I get th...
Hi,
I need to import a text file (fixed-length) into the table.
I have created a DTS package to automate the process, but now i want to do it programmatically from the web application.
...
Error:
Microsoft OLE DB Provider for SQL Server (0x80040E07)
Syntax error converting datetime from character string.
Data Structure:
1 event_id int 4 0
0 grade nvarchar 50 1
0 team n...
Is there any reason why or why not you should do an 'order by' in a subquery? Performance increase if you do? Output is the same either way, right?
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...
I am testing a simple code using Dynamic Cursor. But it gives this run time error.
SQL> @Tr1.sql
WHERE STATUS IN ('I','N')
*
ERROR at line 34:
ORA-06550: line 34...
I am looking for a best practice method for desiginng a social networking database schema similar to linked in. Your direction would be greatly appreciated
I need the code in Teradata that I would place in my select statement that would take the first four digits of a column that is formated like this:
2005-02-02
I also will need the code ...
Hi:
Does anyone have a good tutorial on Data Flow Diagrams?
I am working on a problem in which I have to contruct a level 1 DFD.
Hi,
I have Linux machine (Debian) that runs several databases.
when I doing "du -h /var/lib/mysql" I see that some of my database direcories have big logs files (log.MYD).
How can I fl...
Is there a way in SQL server to set the default date format to dd/mmm/yyyy ?
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...
hi friends
How to convert a date into dd/mm/yyyy fashion directly through SQL.
i know the functions day,month,year.
but is there any other format function which can directly give me a date ...
Hi,
I'm trying to pull some data from active directory, but I can't figure out what the field names are that I'm looking for. The person who originally set up our active directory is no lo...
Hallo Experts.
Someone told me once that I should now and then rebuild the index-tables in oracle for god performance.
Is this true and howto do this?
We have an Oracle 8.05 database with 2...
I'm very green to SQL so please excuse my ignorance...
A contractor setup a SQL server this past weekend and converted our access database to a SQL back end. All is well in house, but a re...
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...
Hello Experts,
I want to ask you some advice about using the receipt printer EPSON TM-U220 A.
I designed a software (FoxPro 7.0) for a restaurant which is using this type of printer. I ins...
