Skip to content

Instantly share code, notes, and snippets.

@shaneis
Created July 19, 2017 15:50
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Save shaneis/a11bb36bdf762fa260e9b189517b9478 to your computer and use it in GitHub Desktop.
New Lines Copy Out Basic
$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