SQL Server SELECT into existing table

Question

SQL Server SELECT into existing table

I'm attempting to choose a few fields from one table and supplement them into an existing table from a stored procedure. Here is the thing that I am attempting:

SELECT col1, col2

INTO dbo.TableTwo 

FROM dbo.TableOne 

WHERE col3 LIKE @search_key

I think SELECT ... INTO ... is for temporary tables which is why I get an error that dbo.TableTwo already exists.

How can I insert multiple rows from dbo.TableOne into dbo.TableTwo?

tsql sql-server sql

3 years ago by vishaljlf39

3 Answers

Login / Signup to Answer the Question.

Login Signup

**akshay1995** · Answer 1 · 2021-06-19T13:06:34

It would work as given below :



insert into Gengl_Del Select Tdate,DocNo,Book,GlCode,OpGlcode,Amt,Narration 

from Gengl where BOOK='" & lblBook.Caption & "' AND DocNO=" & txtVno.Text & ""

**sandhya6gczb** · Answer 2 · 2021-06-21T12:22:12



select 

into existing table database..existingtable

from database..othertables....

If you have used select * into tablename from other tablenames already, next time, to append, you say select into existing table tablename from other tablenames

**RoliMishra** · Answer 3 · 2021-06-22T13:20:54

IF you want an identity column in the new table created with select into then it can be done as below.

SELECT 

 ID = IDENTITY(INT, 1, 1),

        name

INTO    table2

FROM table1

C TUTORIAL

C PROGRAMS

INTERVIEW TESTS

EXECUTE CODE

C++ TUTORIAL

C++ PROGRAMS

INTERVIEW TESTS

EXECUTE CODE

PYTHON TUTORIAL

PYTHON HOW TOS

INTERVIEW TESTS

EXECUTE CODE

JAVA TUTORIAL

JAVA CODE EXAMPLES

SPRING TUTORIAL

MORE IN JAVA

COMPUTER ARCHITECTURE

COMPUTER NETWORK

OPERATING SYSTEM

DBMS & SQL

PL/SQL

MongoDB

EXECUTE SQL

ANDROID DEVELOPMENT

GO LANGUAGE

LINUX

DOCKER

HTML TAGS (A to Z)

CSS REFERENCES

SASS/SCSS

KOTLIN

GAME DEVELOPMENT

PHP

GIT GUIDE

JAVASCRIPT

ADVANCED DSA

SQL Server SELECT into existing table

3 Answers

Login / Signup to Answer the Question.