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

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 65
    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 .

 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: