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
How to disable a login name in ms sql server?
How you can add messages to the nt event log from within a stored procedure?
Why do you want to join software field as you have done your BE in Electronics?
How to scale out a federation by Sql statement?
What will be the maximum number of index per table?
what are different types of backups available in sql server? : Sql server database administration
How do I find the size of a sql server database?
What is the library index called?
How to declare and use cursor variables?
What is a result set object returned by mssql_query()?
How do I find the sql server version?
Describe how to use linked server?
Explain few examples of RDBMS?
Some queries related to SQL
What is sql server programming?