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
- 7992 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 are the disadvantages of indexes?
How to enter comments in transact-sql statements?
What is self contained scalar sub query?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
What is a non-clustered index?
what are database files and filegroups? : Sql server database administration
System variable and temporary variables
How to execute multiple stored procedures at one time in sql server?
What are the advantages of having an index on the sql server?
Delete duplicate rows without using rowid.
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
What are the triggers in sql?
Do you know how to store and query spatial data?
What is multi-statement table-value user-defined function?
What according to you is the difference between mysql and sql server performance?
