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: )

475 reads

Blogs

My T-SQL Tuesday #129 Time Capsule

By

This month the T-SQL Tuesday invitation comes from Tamara Clark. I strong-armed Tamara last...

Azure Database Administrator

By

Recently I found out that I passed the BETA exam for Azure Database Administrator...

SQL on-demand in Azure Synapse Analytics

By

The new SQL on-demand (to be renamed SQL serverless) offering within Azure Synapse Analytics...

Read the latest Blogs

Forums

Time out expired on the application side

By zouzou

Hi   I have an application that is timing out i run the query...

Sum function in CTE is not calculating the right balance

By Ysa

I have table with all charges and payment the charges are 'c'  and payments...

Attacks on Unsecured Databases

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Attacks on Unsecured Databases

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The D in ACID

See possible answers