Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

HOW TO STORE THE PROCEDURE VALUES TO TABLE VARIABLE Expand / Collapse
Author
Message
Posted Saturday, September 07, 2013 11:31 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 3:40 AM
Points: 54, Visits: 148
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
Post #1492578
Posted Sunday, September 08, 2013 12:23 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 11:52 AM
Points: 41,530, Visits: 34,446
INSERT INTO @TableVariable
EXEC StoredProcedure




Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #1492581
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse