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.
- 4 Answers
- 6398 Views
- Value Labs, I also Faced
- E-Mail Answers
Answer Posted / meenaprasanna
insert into table2(Column1,Column2) select Column1,Column2
from Table1 where Column1 %2 ='0'
| Is This Answer Correct ? | 14 Yes | 2 No |
Post New Answer View All Answers
what is the difference between openrowset and openquery?
Tell me what are cursors and when they are useful?
Can you move the resources after pausing the node? : sql server database administration
What is a non-clustered index?
What is the datatype of rowid?
why would you use sql agent? : Sql server database administration
optimization techinques
What is difference between oltp and olap?
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
How does a profiler work?
Describe in brief sql server monitoring ways.
What is data file in computer?
Do you know what is similarity and difference between truncate and delete in sql?
How would we use distinct statement? What is its use?
What is the syntax for encrypting a column in SQL Server?
