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 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...
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...
Hello!
I am having a problem creating an MS ACCESS query that will look through a field in my data table and find all records containing a certain map page.
Can you help me create a sele...
Hello there,
I have downloaded ERwin,but i dont know how to call my database in it,to draw an er diagram for me. when i start erwin i get a connection manager dialog box. in there i choos...
I want to run an update query after a command is clicked on a form. This update query will update all dates to match another date field. What code would I put in to run an update query after...
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...
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...
Here are the two tables:
The first table is "Customer File"
ID Number First Name Last Name Account Balance
1 JOHN CARTER $0.00
2 CHRIS HARRI...
Hello Experts, I am creating a SQL query in Crystal Reports to run against a Sybase db. My select statement is
SELECT
ad.line1
case
when en.firm is not NULL then en.firm
else e...
I have a table that is generated with Dynamic SQL. The columns of the table are built depending on data that is inserted to a table.
I have a stored procedure that pulls data from this tab...
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...
Does someone know some good alternative of MS Access database? For personal use, relatively small records quantity, up to 10.000 For example, music collections catalog, etc
Free, compact siz...
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...
This questions extends previous one re SQL Update Statement in SQL Server 2000. I have managed to replace apostrophe with ’ (due to XHTML!!). The previous field was nvarchar so arguments...
Hi,
What is the equivalent of 'COLLATE' in Oracle 91 ? Does oracle need it ?
I am trying to migrate some sqlserver scripts into oracle.
create table [Stats] (
[id] [int] not null,
...
Hi,
I created a view... and I want the view to give me "Today's Date" if a certain date field is blank...
But I'm not sure how to tell the view to give me today's date.
WHEN dtApproved ...
Is there a easy way to use the prompt output command with dates Eg, I need to get the following output instead of using DBMS
report for 01-JAN-2003 to 30-JAN-2003.
I need to get this on ...
We basically need to create HS connectivity from Oracle 11G database to SQLServer, For this I have installed Data Direct ODBC 64 bit connectivity:
But when I try to run the following query ...
PROBLEM: Receive error message:
Server: Msg 105, Level 15, State 1, Line 128
Unclosed quotation mark before the character string 'Un
into NewTable FROM (select tbl_ecom_productdescriptor...
Hi
After database is restored, is it nesscary to update statistics on all table and reorg rebuild all table again?
As I have experienced that there is very poor performance after the DB i...
My customer is running SQL svr on Winxp machine. All was working fine until today. For some reason, when he was surfing the internet his computer just shut itself down. He rebooted and ever...
I am able to use the Relations link on my ERD diagram that I created in Visio and tell it one-to-many, etc., but how can I get the actual one-to-many and other symbols to show on the actual li...
I could't find any explaination about this error message from Oracle8 help file. Normally we will get 5 digits number but this is 6 digits number.. and start with number 3.. emm..
I got thi...
That's an easy one, but I'm new to DB2 and I really just need write a quick query, so here it goes:
What's the "DB2 equivalent" for SQL Server's IsNull() and for DateAdd() ?
Definitions ...
