is this possible

Chethan Jk

Hallo friends... is this possible ... I have two tables whereby I want to insert to table 2 by selecting from table 1 and then delete all the data in table 1

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajanikant Hawaldar4y ago

check it

with delete_cte as 
(delete from table 1
returning *)
insert into table 2
select * from delete_cte;

Vishal Joshi4y ago

Hello,

Yes, it's possible. please find below a sample SQL server query to achieve the same.

-- Insert value from Table_1 to Table_2
INSERT INTO Table_2 SELECT ID,Value,Type FROM Table_1 WITH(NOLOCK)
-- We can add where clause to insert diffrent value

-- Insert value from Table_1 to Table_3
INSERT INTO Table_3 SELECT ID,Value,Type FROM Table_1 WITH(NOLOCK)

--Delete values from Table_1
DELETE FROM Table_1

--We can also use truncate 
--TRUNCATE TABLE Table_1