Skip to content

Instantly share code, notes, and snippets.

@phpleo
Created July 6, 2011 17:42
Show Gist options
  • Select an option

  • Save phpleo/1067849 to your computer and use it in GitHub Desktop.

Select an option

Save phpleo/1067849 to your computer and use it in GitHub Desktop.
Select en stored procedure
-- http://stackoverflow.com/questions/653714/how-to-select-into-temp-table-from-stored-procedure
declare @temp table
(
name varchar(255),
field varchar(255),
filename varchar(255),
filegroup varchar(255),
size varchar(255),
maxsize varchar(255),
growth varchar(255),
usage varchar(255)
);
INSERT @temp Exec sp_helpfile;
select * from @temp;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment