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
7642 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

Explain the properties of a relational table?

975

What is difference between primary key and foreign key?

833

What authentication modes does sql server support?

1014

What is the difference between DataRow.Delete() and DataRow.Remove()?

1163

Explain the cursor lock types?

978

What is sql server profiler?

949

How to convert numeric expression data types using the cast() function?

1000

Which joins are sql server default?

936

How do I view a trc file?

897

Can you move the resources after pausing the node? : sql server database administration

1039

Explain aggregate functions?

1024

How to copy data from one table to another table?

930

What are truncate options available in sql server? : sql server database administration

965

What is the New in SQL server 2008?

916

What is change data capture (cdc) in sql server 2008?

976