New answers tagged

1 vote

Insert 2 output result sets from sp_spaceused into Temp Table (SQL Server non-2016)

A trick to inserting two result sets into one table? No. I do not believe that is possible. However, what I've done in the past, as I'm sure you have experimented with, is modify the code inside the ...
Caleb Carl's user avatar
-1 votes

Insert 2 output result sets from sp_spaceused into Temp Table (SQL Server non-2016)

CREATE TABLE #DatabaseSizes_4 ( database_name NVARCHAR(128), database_size VARCHAR(18), unallocated_space VARCHAR(18), reserved VARCHAR(18), data VARCHAR(18), index_size ...
Fausto Ojeda Moreno's user avatar

Top 50 recent answers are included