Skip to content

Instantly share code, notes, and snippets.

@shaneis

shaneis/NewLines_FileOutBasic.ps1

Last active July 26, 2017 16:21
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save shaneis/214aec1719a9d18e46c2d51d1a4aea55 to your computer and use it in GitHub Desktop.
Save shaneis/214aec1719a9d18e46c2d51d1a4aea55 to your computer and use it in GitHub Desktop.
Download ZIP
New Lines File Out Basic
Raw
NewLines_FileOutBasic.ps1
$NewLineQuery = 'SELECT Notes FROM dbo.NewLineNotes'
$InvSQLParams = @{
ServerInstance = '0738-5CG140G7T\SQLSERVER2K16'
Database = 'Pantheon'
Query = $NewLineQuery
}
Invoke-Sqlcmd @InvSQLParams |
Select-Object -Property Notes |
Export-Csv -Path 'C:\Users\soneill\Desktop\In Progress\Test\NewLines.csv' -NoTypeInformation
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment