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
- 7835 Views
- Value Labs, I also Faced
- E-Mail Answers
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
What is a deadlock and what is a live lock?
What is a result set object returned by mssql_query()?
How do you start single user mode in clustered installations?
What is row_number () and partition by in sql server?
What does REVERT do in SQL Server 2005?
Which trace flags are enabled in sql server?
What are the advantages of having an index on the sql server?
What is default port number for sql server 2000?
What's new in sql management studio for sql server? : sql server management studio
What are Spatial data types in SQL Server 2008
How to add a new dsn with the odbc driver for sql server?
How would you go about developing a ssrs report?
What is relationship? What number of sorts of relationship are there?
Is resultset an interface?
Call by value and call by reference in procedure and function, with NOCOPY.
