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
- 7650 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
Write the syntax for stuff function in an sql server?
What is policy based management (pbm)? : sql server database administration
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
Explain primary key in sql server?
Explain what is the use of custom fields in report?
What are the export options of ssrs?
Tell me what are cursors and when they are useful?
What is intellisense?
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
what are the different ways to return the rowcount of a table?
What is replication and database mirroring?
What is the difference between rank and dense_rank?
How to use subqueries with the in operators in ms sql server?
How do I start sql server 2017?
What is shrink log file?
