insert into table2(Column1,Column2) select Column1,Column2 from Table1 wh

Please give me the SP for the below scenario. I have two
tables named Table1 and Table2...I need to fetch record by
record from Table1 and insert the record in to table2 where
the value in the sno column of the table1 is even number.

Question Posted / mythili

4 Answers
7771 Views
Value Labs, I also Faced
E-Mail Answers

Answer Posted / mythili

insert into table2(Column1,Column2) select Column1,Column2
from Table1 where Column1 %2 ='0'

Is This Answer Correct ?

13 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What do you understand by the analysis services in sql server?

930

What are parameterized reports? What are cascading parameters in ssrs reports?

156

How many types of local tables are there in sql server?

915

Is resultset an interface?

939

Does windows server 2016 come with sql server?

919

What is database mirroring?

1093

How to concatenate two strings in SQL Server.

1137

What is unpivot?

999

Write a sql query to display the current date?

1075

How you provide security to cube? : sql server analysis services, ssas

951

What authentication modes does sql server support?

1071

Do you know what is a linked server in sql server?

1004

How to concatenate two character strings together?

1101

What is #table in sql server?

1030

What is update_statistics command?

1047