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.
Answer Posted / meenaprasanna
insert into table2(Column1,Column2) select Column1,Column2
from Table1 where Column1 %2 ='0'
| Is This Answer Correct ? | 14 Yes | 2 No |
Post New Answer View All Answers
Do you know data definition language, data control language and data manipulation language?
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.
How do we synchronize On-Premise SQL server with SQL Azure?
how many layers of tcp/ip protocol combined of? : Sql server database administration
How to set the current database in ms sql server?
What are the different sql server versions?
Mention the differences between substr and charindex in sql server.
How to loop through result set objects using mssql_fetch_array()?
What is the difference between a function and a stored procedure?
Can group functions be mixed with non-group selection fields in ms sql server?
What happens to a statement batch if there is a compilation error?
Explain concepts of analysis services?
Explain can you implement data mining in ssrs?
What is a trigger? Why we need it?
What are the differences between clustered and non-clustered index?