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
- 7802 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 difference between char, varchar and nvarchar?
What is the difference between left and right outer join?
How do I view a script in sql server?
What is the purpose of sql profiler in sql server? : sql server database administration
What are the differences between local and global temporary tables?
what is the difference between a primary key and a unique key? : Sql server database administration
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
What are the advantages of having an index on the sql server?
If you want to send some data from access database to sql server database. What are different component of ssis will you use?
What is a field name?
Can two different columns be merged into single column? Show practically?
What is attribute hierarchy? : sql server analysis services, ssas
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
What is data file in computer?
How to use subqueries with the exists operators in ms sql server?
