sqlserver 分割
select * from (
select a1.*,c.name as okWhen running sp_spaceused for years, I have gotten results like this:
When running sp_spaceused for years, I have gotten results like this:
This gives me two result sets, which are hard to manage.
On my new SQL Server 2016 instance, how can I get all of this data into a single result set in the easiest way possible?
Correct answer: | Use the @oneresultset parameter set to 1 |
Explanation: | The sp_spaceused procedure has a parameter, @oneresultset, which will return a single result set when set to 1. Ref: Sp_spaceused - https://msdn.microsoft.com/en-us/library/ms188776.aspx |
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/69953058/viewspace-3161087/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
