can i have statement like this:
insert into table2
....
..
select (... ,.., , from table1, table3 where table1.id = table3.id)
Thanks a lot for your help
Hi,
I have ERWIN installed but I cannot connect to Oracle databases. Specifically, I've tried to connect to an Oracle DB 10g DB on Linux and an Oracle Express 10g DB on Windows XP
I get sa...
Hi
I have an Access 2002 Database file that I'm trying to access from both a Visual Basic 6 project and an ASP page (running on Windows XP IIS 5.1).
The VB6 connection string is as follo...
For SQL Server 2000, I'd like to know the way of looking the database and log size with the Query Analizer. sp_spaceused gives only the current usage. I want to find the total size of the data...
Hello experts,
How do I save my query results into a temporary table and then delete it?
In MS SQL it would be like
Select Column1
Into #Temp1
From Table
Select *
From #Temp1
...
hi
we have oracle 8i(817) in our site and we want upgrade to oracle9i what i must to do?
what is the steps of it?
thanks
Hi..i got this error when i want to run the form...please help..thanks.
I'm putting together an ERD for a medical practice application. So far I have the following:
employees (doctors, nurses, admin staff)
patients
practices (where doctors, nurses, admin staf...
Hi,
I have a bunch of data files from an old application that i would like to pull reports from with say microsoft acces. I believe they are btrieve base but am not sure.. They are semi rea...
I have a table on a php page that allows entry of data into fields in my database. You can see a picture attached below.The entire table has inputs, meaning the top axis, side axis as well as ...
Can I get sum() and count(*) in one statement like:
CASE WHEN t.posting_date between @period_start and @prm_cmp_start_date
THEN SUM(t.gross_amount) AS Sales, COUNT(t.gross_amount) AS Trad...
I have a unix script that I am check a data file record count. When I do the following I get the count and the file name assign to the variable. How can I get just the record count?
TOTAL_...
I have two tables in Access that have the exact same columns but different data. I want to query Table A and Table B to find all records with duplicate values in Column A (lets say there are C...
Hello Experts,
I am trying to insert multiple select statements into a table residing on SQL Server 2000, which looks similiar to the query indicated below.
Insert into (Table_Name,Colum...
I'm trying to create a select statement that will return a percentage and the record it is for. For example, say I have
Table A:
FRUIT | COST
------------------
Apple | 50
Orange |...
I have the following SQL query I am working with that parses correctly and appears to be valid:
Code:
INSERT INTO DestinationDB.dbo.DestinationTable
(id, Location, [Last Name], [First...
Could you summarize each Database System's function, requirements, expansion capabilities and how the database is being used and the cost associated with its use. I am an accountant going to ...
Informix
Is there a way how to retrieve a value of DATATIME field in Informix table in 'YYYYMMDD' format (with NO dashes or slashes between year,month and day) using an SQL query (in dbacce...
Hi,
I am trying to use the dbms_lock.sleep comman in a procedure like this for example :
create or replace procedure testing as
begin
dbms_output.put_line('we gonna go to sle...
I'm storing variable-length docmunts in a database using a column defined as varbinary(max).
Is there a simple SQL query to get the actual length of a varbinary column in a specific row?
In reporting services I have a matrix table that displays the total number of allow and denied for each month. For the total "% of Denied" in the "Year To Date" column I get the letter "NaN" ...
I want to create a pretty diagram in Visio 2003. I don't care about the diagram linking back to a real database (in SQL Server). I have some DDL SQL script for several tables that I want to g...
I need to put together a list of all of the table field names in my 2003 MS Access database. How can I easily do that?
Hello experts,
I have a column that has names. The names is in a format like this:
"LastName,FirstName"
I would like to add a space after the comma. Do any of you know the syntax to...
any one have mscomctl2.ocx or mscomct32.ocx, thanks
