Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • How to Copy entire date into other table in SQL Database

    @mukesh.tomar
    Recommendations Offline Message

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 218
    Comment on it

    SQL Copy Table
    If you want to copy a SQL table into another table in the same SQL database then you can do with the copy statement .
    Syntax ->

    select * into destinationTable from sourceTable ;

    Example ->

    **Student name**               **Student Age**         **Student Id**
      Mukesh                       23                        1
      Ayush                        24                        2

    select * into studentInfo from student ;

    So student table data will copied into studentInfo .

    SQL copy data
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           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: