Ce site est optimisé pour être consulté depuis un navigateur moderne dans lequel JavaScript est activé.

SQL Server SELECT into existing table

ayi

<t>SQL Server SELECT into existing table</t>

ayi

<t>SELECT ... INTO ... only works if the table specified in the INTO clause does not exist - otherwise, you have to use:<br/>
<br/>

INSERT INTO dbo.TABLETWO<br/>
SELECT col1, col2<br/>
  FROM dbo.TABLEONE<br/>
 WHERE col3 LIKE @search_key<br/>
<br/>
```<br/>
<br/>
This assumes there's only two columns in dbo.TABLETWO - you need to specify the columns otherwise:<br/>
<br/>
```<br/>
INSERT INTO dbo.TABLETWO<br/>
  (col1, col2)<br/>
SELECT col1, col2<br/>
  FROM dbo.TABLEONE<br/>
 WHERE col3 LIKE @search_key<br/>
<br/>
```</t>