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
- 7978 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
Explain microsoft sql server functions?
can an order by clause be used in a creation of a view?
What types of replication are supported in sql server?
how many layers of tcp/ip protocol combined of? : Sql server database administration
What is a heap?
List out the difference between union and union all in sql server?
how many clustered indexes can be created on a table? : Sql server database administration
What is data compression?
How do you delete a data source?
What is the use of group by clause?
What is database replication? What are the different types of replication you can set up in sql server?
What is sqlcmd?
What are the advantages of using cte?
What is the maximum size of a dimension? : sql server analysis services, ssas
What is awe?
