Invoke-Sqlcmd cmdlet in SQL Server with PowerShell

preview_player
Показать описание

No Uber-scripting language would be complete without the ability to store and retrieve data from a database. In this video excerpt from Robert Cain's new course PowerShell and SQL Server you'll see how to use the Invoke-SqlCmd commandlet to query a SQL Server database and how to inspect the data it returns. In the full course he also covers topics such as performing basic DBA tasks, developer-centric tasks, and real world topics.

Visit us at:

Invoke-Sqlcmd cmdlet in SQL Server with PowerShell | Pluralsight

-~-~~-~~~-~~-~-
Push your limits. Expand your potential. Smarter than yesterday-
-~-~~-~~~-~~-~-
Рекомендации по теме
Комментарии
Автор

Do you do the SQL powershell tasks on the SQl server or SQL client with SMO installed

maggiehsu
Автор

Has this behavior changed in newer versions? All I get is "System.Data.DataRow" for each item that I should be getting.

fcanapa
Автор

Is there a command to invoke myself to complete my project?

exdrus