CODEWITHSUNDEEP
sqlsql-server-2008
asd
asd

Reputation: 15

SQL: Select One column into a column in another table

Select ISO_2_LETTER_CODE 
from #TempTable
INTO ODBCTest

But i keep getting error:Incorrect syntax near the keyword 'INTO'.

Upvotes: 0

Views: 786

Answers (2)

Mythik
Mythik

Reputation: 11

The syntax for SELECT INTO is:

SELECT Column1, Column2, Column3, INTO Table2 FROM Table1

So The syntax would be:

SELECT ISO_2_LETTER_CODE INTO ODBCTest FROM #TempTable

Upvotes: 1

Randy Minder
Randy Minder

Reputation: 48392

I think your syntax is wrong. Try this:

Select ISO_2_LETTER_CODE
INTO ODBCTest
From #TempTable

Upvotes: 1

Related Questions