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
- 7831 Views
- Value Labs, I also Faced
- E-Mail Answers
Answer Posted / mythili
insert into table2(Column1,Column2) select Column1,Column2
from Table1 where Column1 %2 ='0'
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
What is the sql case statement used for? Explain with an example?
How many tables can be joined in SQL Server?
What are the types of containers in ssis?
What are the limitations in ssrs on sql server express edition?
Can you explain different types of locks in sql server?
Tell me when is the update_statistics command used?
How to download microsoft sql server 2005 express edition?
Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?
What is thr feature of change data capture?
What is user-defined scalar function?
How to write a query with a right outer join in ms sql server?
Explain Geography datatype in SQL Server
What is an identity?
What is named query? : sql server analysis services, ssas
How to find out the list schema name and table name for the database?
