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 is named calculation? : sql server analysis services, ssas
What is SubQuery in SQL Server 2008
What are the restrictions that views have to follow?
What are the database roles? : sql server security
What is the default schema of your login session in ms sql server?
Describe in brief sql server monitoring ways.
What is openxml in sql server?
What do you mean by subquery?
Please explain go command in sql server?
what types of replication are supported in sql server? : Sql server database administration
Explain error handling in ssis?
Is it important for a database administrator to understand the operating system and file access?
What are system databases in ms sql server?
What is format parameter in ssrs?
What are the tool windows in sql server management studio? : sql server management studio