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.
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
Why we use functions in sql server?
What is a document index?
What is sql server 2000 work load governor?
What is the use of custom fields in report?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Can you please explain the difference between function and stored procedure?
Is it possible for a stored procedure to call itself or recursive stored procedure?
How many types of triggers are there?
What authentication modes does sql server support?
what is the sql equivaent of the dataset relation object ?
Explain go command in sql server?
what is a join? : Sql server database administration
What is the rdl file?
What is the New in SQL server 2008?
Explain the types of indexes.