Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
Node is saved as draft in My Content >> Draft

  • Copy and create temp table from main table

    @HIMANSHU
    Recommendations Offline Message

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 32
    Comment on it

    In SQL we have situations, where we want to manipulate our data based on conditions .


    For doing that one approach we need is to store that data into temp table then manipulate it.


    For doing this we copy the entire structure of the main table into temp table


    Ex:

SELECT * INTO temptale from assignment


    If you want selected records say you want only those details which have ID greater than 4


    Ex:
    SELECT * INTO temptale from assignment  where stid>4
    SQL
    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: