by: JC-Atl |
last post by:
I have 2 tables in a database:
As an example, let's say Table1 has 20 rows, like this:
Table1:
CategoryNumber CategoryName
1000 Radios
1001 CD...
|
by: ja |
last post by:
hi,
How copy two table between two database?
copy 1 table1 to 2 table2
1 - cursor number,
2 - cursor number,
table1 - sourse table
table2 - destination table
|
by: Peter CCH |
last post by:
Let's say, I have Table1 and Table2, both with the exactly same
structure and data in it, except that Table1.Field1 is empty in data
but Table2.Field1 have data in it.
How could I copy all the...
|
by: Dejan |
last post by:
Hy
Sorry for my terreble english.
I have mysql table1 on my local comp. It looks something like this.
----------------------------------------------------------------------------
-...
|
by: GTi |
last post by:
I have two identical tables with one IDENTITY column and several other
columns.
I have tested the COPY * INTO table2 FROM table1 WHERE xx
but it requers that table2 does not exist.
TABLE2 is a...
|
by: Hetal |
last post by:
Hi..
I am working on VB.NET 2003 (windows form) application and using
ADO.NET to deal with databases. The table structure i am working with
is as follows.
DB1.Table1 (source)...
|
by: pbd22 |
last post by:
Hi.
Like the title says - how do i do this?
I was given the following example:
INSERT INTO TABLE2 SELECT * FROM TABLE1 WHERE COL1 = 'A'
The above statement threw the following error:
|
by: Yas |
last post by:
Hello,
I have 2 tables, Table1 and Table2. I have copied all data from Table1
to Table2.
However Table1 is dynamic it has new rows added and some old rows
modified everyday or every other...
|
by: suren1503 |
last post by:
Hi All Techies,
I have created one DTS to copy table1 (which is on Oracle server) to table2 (on SQL Server 2000)
I want to copy only new records + modified records from table1 to table2.
I...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|