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
- 7647 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 key attribute?
What is the fillfactor concept in indexes?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
Do you know exporting and importing utility?
What is the purpose of indexing?
How do you manipulate data?
What is rs.exe utility?
Explain indexing and what are the advantages of it?
How to bind a view to the schema of the underlying tables?
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
Differentiate between a primary key and a unique key.
What is the server name for sql management studio?
How do you make a trace?
How can you know if the row fetched from cursor is still valid in underlying table?
Why does sql studio use a single registered database repository? : sql server management studio
