The SQL SELECT INTO statement is used to select data from a SQL database table and to insert it to a different table at the same time.
The general SQL SELECT INTO syntax looks like this:
SELECT Column1, Column2, Column3,
INTO Table2
FROM Table1
The list of column names after the SQL SELECT command determines which columns will be copied, and the table name after the SQL INTO keyword specifies to which table to copy those rows.
If we want to make an exact copy of the data in our Customers table, we need the following SQL SELECT INTO statement:
SELECT *
INTO Customers_copy
FROM Customers
Popular Posts
-
Data Types in VB .NET The Data types available in VB .NET, their size, type, description are summarized in the table below. Data Type Size i...
-
Methods A Method is a procedure built into the class. They are a series of statements that are executed when called. Methods allow us to han... -
Creating DataTable Visual Basic allows us to create our own Tables and work with them. The DataTable is an in-memory representation of a blo... -
JSP pages are high level extension of servlet and it enable the developers to embed java code in html pages. JSP files are finally compiled ...
-
The SQL AND clause is used when you want to specify more than one condition in your SQL WHERE clause, and at the same time you want all con...
-
Constructors A constructor is a special member function whose task is to initialize the objects of it's class. This is the first method ...
-
Introduction: In this exercise, you will exercise the concept of pass by reference. Please not that primitive type parameters are passed ...
-
Using SQL Parameters In VB.NET, we have Windows controls that may provide parameters for filtering data from the database. A common scenario... -
Interfaces Interfaces allow us to create definitions for component interaction. They also provide another way of implementing polymorphism. ... -
Changing the button's Properties Now you have a button on your form. You can change its location by dragging it, and change its size by ...
No comments:
Post a Comment