Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7829 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
How do I partition a table in sql server?
Where views are stored in sql server?
what is a check constraint?
How to enter date and time literals in ms sql server?
Your table has a large character field there are queries that use this field in their search clause what should you do?
What is the contrast amongst drop and truncate?
Explain optimistic and pessimistic concurrency?
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
Explain can SSRS reports Cache results?
How to download and install microsoft sql server management studio express?
How to find related tables in sql server?
Why can there be only one clustered index and not more than one?
Write a code to select distinct records without using the DISTINCT keyword.
What is the difference between Triggers and Stored Procedure?
