Post reply

HOW TO STORE THE PROCEDURE VALUES TO TABLE VARIABLE

  • September 7, 2013 at 11:31 pm

    #279582

    HI,

    i got one doubt ...

    SP_SPACEUSED 'table'

    the above statement can produce some data...

    how can i store that data to table variable.

    is there any way to get and store the result of this statement SP_SPACEUSED 'table' ?

    Please help...

    Thanks

    Dastagiri

  • September 8, 2013 at 12:23 am

    #1648374

    INSERT INTO @TableVariable

    EXEC StoredProcedure

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply