Skip to content

Instantly share code, notes, and snippets.

@shaneis

shaneis/NewLines_CopyOutBasic.ps1

Created July 19, 2017 15:50
Show Gist options
  • Save shaneis/a11bb36bdf762fa260e9b189517b9478 to your computer and use it in GitHub Desktop.
Save shaneis/a11bb36bdf762fa260e9b189517b9478 to your computer and use it in GitHub Desktop.
Download ZIP
New Lines Copy Out Basic
Raw
NewLines_CopyOutBasic.ps1
$NewLineQuery = 'SELECT Notes FROM dbo.NewLineNotes'
$InvSQLParams = @{
ServerInstance = 'localhost\SQLSERVER2K16'
Database = 'Pantheon'
Query = $NewLineQuery
}
Invoke-Sqlcmd @InvSQLParams |
Select-Object -ExpandProperty Notes
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment