Copiare i dati da una tabella all'altra - Revision history

Gabriele.vivinetto: /* Copiare solo alcune colonne da una tabella all'altra in un altro database */

2009-03-11T14:12:19Z

Copiare solo alcune colonne da una tabella all'altra in un altro database

← Older revision		Revision as of 14:12, 11 March 2009
Line 34:		Line 34:

	To do this you just need to fully qualify (<database>.<owner>.<table name>) the source and target table names on the INSERT INTO statement to identify which database you want to use.		To do this you just need to fully qualify (<database>.<owner>.<table name>) the source and target table names on the INSERT INTO statement to identify which database you want to use.




	QUESTO INVECE NON SI PUÒ FARE !		QUESTO INVECE NON SI PUÒ FARE !

Gabriele.vivinetto: /* Copiare solo alcune colonne da una tabella all'altra in un altro database */

2009-03-11T14:12:04Z

Copiare solo alcune colonne da una tabella all'altra in un altro database

← Older revision		Revision as of 14:12, 11 March 2009
Line 34:		Line 34:

	To do this you just need to fully qualify (<database>.<owner>.<table name>) the source and target table names on the INSERT INTO statement to identify which database you want to use.		To do this you just need to fully qualify (<database>.<owner>.<table name>) the source and target table names on the INSERT INTO statement to identify which database you want to use.


	QUESTO INVECE NON SI PUÒ FARE !		QUESTO INVECE NON SI PUÒ FARE !


	You can copy data from one server to another the same way by using fully qualified linked server names <linked_server>.<database>.<owner>.<table_name>).		You can copy data from one server to another the same way by using fully qualified linked server names <linked_server>.<database>.<owner>.<table_name>).

Gabriele.vivinetto: /* Copiare solo alcune colonne da una tabella all'altra in un altro database */

2009-03-11T14:11:50Z

Copiare solo alcune colonne da una tabella all'altra in un altro database

← Older revision		Revision as of 14:11, 11 March 2009
Line 35:		Line 35:
	To do this you just need to fully qualify (<database>.<owner>.<table name>) the source and target table names on the INSERT INTO statement to identify which database you want to use.		To do this you just need to fully qualify (<database>.<owner>.<table name>) the source and target table names on the INSERT INTO statement to identify which database you want to use.

			QUESTO INVECE NON SI PUÒ FARE !
	You can copy data from one server to another the same way by using fully qualified linked server names <linked_server>.<database>.<owner>.<table_name>).		You can copy data from one server to another the same way by using fully qualified linked server names <linked_server>.<database>.<owner>.<table_name>).


	== Link utili==		== Link utili==

	Preso da [http://www.databasejournal.com/features/mssql/article.php/3507171 Transferring Data from One Table to Another]		Preso da [http://www.databasejournal.com/features/mssql/article.php/3507171 Transferring Data from One Table to Another]

Gabriele.vivinetto at 14:45, 30 August 2005

2005-08-30T14:45:47Z

← Older revision		Revision as of 14:45, 30 August 2005
Line 1:		Line 1:
			[[Category: Mysql]]

	== The INSERT INTO Method ==		== The INSERT INTO Method ==

Gabriele.vivinetto at 18:31, 16 August 2005

2005-08-16T18:31:58Z

New page

== The INSERT INTO Method ==

This method, as the heading suggests, uses the INSERT INTO T-SQL statement to move records from one table to another. This method is one of the easiest methods of transferring data. This method can not only be done between tables on the same server, but can also be done across servers.

To use this method, all you have to do is code an INSERT INTO statement that identifies the target table, and uses a SELECT statement to identify the data you want to copy from the source table. Let me show you an example. Say you have two tables TABLE1, and TABLE2, where both tables have exactly the some table structure and are in the same database.

== Copiare tutte le colonne di tutti i record da una tabella all'altra ==

In this case, to copy all the rows from TABLE1 to TABLE2 you would use the following INSERT INTO statement:

INSERT INTO TABLE2 SELECT * FROM TABLE1

== Copiare tutte le colonne di alcuni record da una tabella all'altra ==

Now suppose you do not want to copy all the rows, but only those rows that meet a specific criteria. Say you only want to copy those rows where COL1 is equal to "A." To do this you would just modify the above code to look like this:

INSERT INTO TABLE2 SELECT * FROM TABLE1 WHERE COL1 = 'A'

See how simple it is to copy data from one table to another using the INSERT INTO method?

== Copiare solo alcune colonne da una tabella all'altra ==

You can even copy a selected set of columns, if you desire, by identifying the specific columns you wish to copy and populate, like so:

INSERT INTO TABLE2 (COL1, COL2, COL3) SELECT COL1, COL4, COL7 FROM TABLE1

The above command copies only data from columns COL1, COL4, and COL7 in TABLE1 to COL1, COL2, and COL3 in TABLE2.

== Copiare solo alcune colonne da una tabella all'altra in un altro database ==

This method can also be used to copy data from one database to another.

To do this you just need to fully qualify (<database>.<owner>.<table name>) the source and target table names on the INSERT INTO statement to identify which database you want to use.

You can copy data from one server to another the same way by using fully qualified linked server names <linked_server>.<database>.<owner>.<table_name>).

== Link utili==

Preso da [http://www.databasejournal.com/features/mssql/article.php/3507171 Transferring Data from One Table to Another]