rajesh


{ City } munbai
< Country > india
* Profession * support engg.
User No # 81625
Total Questions Posted # 0
Total Answers Posted # 2

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 1
Users Marked my Answers as Wrong # 5
Questions / { rajesh }
Questions Answers Category Views Company eMail




Answers / { rajesh }

Question { 3935 }

What is stored procedure in SQL..??


Answer

Stored procedure is set of SQL statements

Is This Answer Correct ?    0 Yes 0 No

Question { Cap Gemini, 7141 }

How to a Query to copy data from on table to another table.


Answer

we have to use INSERT INTO method.
with the use of this method we can easily transfer records
from one table to another table.we can not only use this
method in the same server but can aslo be done across the
server.for exmaple.if we have two table A1 and A2 then the
code is
INSERT INTO A2 select * from A2.

Is This Answer Correct ?    1 Yes 5 No