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
- 7809 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
What are the purpose of Normalisation?
What types of Joins are possible with Sql Server?
How can windows applications connect to sql servers via odbc?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
How can we migrate from SQL server to SQL Azure?
How to divide query output into multiple groups with the group by clause in ms sql server?
What is SQL Azure?
What do you understand by integration services in sql server?
How do I run a trace in sql server?
Explain the purpose of indexes?
what is the difference between delete table and truncate table commands? : Sql server database administration
What are the different index configurations a table can have?
What are the advantages to use stored procedures?
In what three ways is the return statement used in a stored procedure?
how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }
