Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • What is process to Copy entire date into other table in SQL Database ?

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 116
    Comment on it

    Hi Reader's,
    Welcome to FindNerd, today we are going to discuss what is process to Copy entire date into other table in SQL Database ?

    If you want to copy a SQL table into another table in the same SQL database then you should use copy statement.

    Syntax of SQL Copy Table

    select * into destinationTable from sourceTable ;

    you can see below example:

    suppose you have a table name is employee

     **Employee name**  **Employee Age** **Employee Id**
              Deepak                         30                            1
              Nishant                         25                            2   

     Now you want copy to same record another table in same database   

    INSERT INTO employeeinfo SELECT * FROM employee;

    So student table data will copied into employeeinfo.

     

 0 Comment(s)

Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: