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
- 6372 Views
- Value Labs, I also Faced
- E-Mail Answers
Answer Posted / rajesh.a
insert into table2(Column1,Column2) select Column1,Column2
from Table1 where Column1%2 = 0
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What are the tables in sql?
Why do you need a sql server?
What happens if date-only values are provided as date and time literals?
Do you know what are various aggregate functions that are available?
What is table constraint?
How do I edit a procedure in sql server?
Can primary key be a foreign key?
How to stop a loop early with break statements in ms sql server?
Do you know concepts and capabilities of sql server?
What is the need for group functions in sql?
what changed between the previous version of sql server and the current version? : Sql server database administration
How to download and install microsoft .net framework version 2.0?
What is resource db in sql server?
what is raid and what are different types of raid configurations? : Sql server database administration
What information is maintained within the msdb database?
