dotNETportal.cz

Caute stretol sa niekto uz s prikazom SELECTINTO? Ak ano ako sa spravne zapisuje. Ak to napisem napr. vo visual studiu

SELECT * INTO obraz FROM vzor

tak mi to neprejde.

vdaka

cujan

Je to tak jak píšete.

SELECT * INTO table1 FROM table2

Jedná se v podstatě(alespon já to tak chápu) o alternativu k příkazu

INSERT INTO table1 (SELECT něco FROM table2)

Jasne je to v podstate alternativa, len to vlastne urobi akusi kopiu vzorovej tabulky. Len ja ked to hodim do VS ta mi vypise nasledujucu chybu:

SQl Execition Error.

executed sql statement : SELECT * INTO table1 FROM table2

Error Source: SQL Server Compact ADO.NET Data Provider

Error Message: there was an error parsing the query.

token line number =1, token line ofset = 10 token in error = INTO

Neviem ci nemam len nahodou nieco zle nastavene.

cujan

Snad ti to pomuže mne to take zaujalo protože teď dělám jeden malý projekt a asi vím že to použiju také

We use the following SQL statement:

SELECT *

INTO Persons_Backup

FROM Persons

We can also use the IN clause to copy the table into another database:

SELECT *

INTO Persons_Backup IN 'Backup.mdb'

FROM Persons

We can also copy only a few fields into the new table:

SELECT LastName,FirstName

INTO Persons_Backup

FROM Persons

SQL SELECT INTO - With a WHERE Clause

We can also add a WHERE clause.

The following SQL statement creates a "Persons_Backup" table with only the persons who lives in the city "Sandnes":

SELECT LastName,Firstname

INTO Persons_Backup

FROM Persons

WHERE City='Sandnes'

SQL SELECT INTO - Joined Tables

Selecting data from more than one table is also possible.

The following example creates a "Persons_Order_Backup" table contains data from the two tables "Persons" and "Orders":

SELECT Persons.LastName,Orders.OrderNo

INTO Persons_Order_Backup

FROM Persons

INNER JOIN Orders

ON Persons.P_Id=Orders.P_Id

S tím rozdílem, že novou tabulku vytváří. Není tedy možné provést na tabulce, která již existuje.