Friday, November 2, 2012

Hello All,

     From Recent Search , Vinay find good  & quick solution for inserting record from one old table to new table, with specific columns

 
 INSERT INTO new_table (columns....)
SELECT columns....
FROM initial_table where [condition]

using this query we can insert some records form old table to new table with given condition.
thanks vinay for your solution.

No comments:

Post a Comment