Output multiple datasets from one INVOKE-SQLCMD command

A common question that I've seen online is how do I return multiple sql datasets from a single query using INVOKE-SQLCMD. Most of the answers out there say it is not possible, but it is in fact possible by using the OutputAs dataset parameter. This parameter outputs a dataset that has all of the information […]

2020-04-24 (first published: )

572 reads

Blogs

Power BI Monthly Digest – October 2020

By

In this month’s Power BI Digest Matt and I will again guide you through...

Daily Coping 26 Oct 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Welcome to 3Cloud …

By

A little over a month ago, Pragmatic Works Consulting was a part of a...

Read the latest Blogs

Forums

what does it mean for the following SQL Scripts

By 892717952

in a stored procedure, I found two line sql scripts "    if @@microsoftversion > 0x07320000 exec sp_MSreplraiserror 20598...

Recovering Databases From a Master Backup

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Recovering Databases From a Master...

The Next Evolution of Big Blue

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Next Evolution of Big...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers