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 / 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 do you understand by the analysis services in sql server?
What are parameterized reports? What are cascading parameters in ssrs reports?
How many types of local tables are there in sql server?
Is resultset an interface?
Does windows server 2016 come with sql server?
What is database mirroring?
How to concatenate two strings in SQL Server.
What is unpivot?
Write a sql query to display the current date?
How you provide security to cube? : sql server analysis services, ssas
What authentication modes does sql server support?
Do you know what is a linked server in sql server?
How to concatenate two character strings together?
What is #table in sql server?
What is update_statistics command?