Skip to content

Instantly share code, notes, and snippets.

@shaneis

shaneis/NewLines_FileOutBasicSpecialChars.ps1

Created 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/0f50f6198b26dd814b1f627655f6adf7 to your computer and use it in GitHub Desktop.
Save shaneis/0f50f6198b26dd814b1f627655f6adf7 to your computer and use it in GitHub Desktop.
Download ZIP
New Lines File Out Basic Special Char
Raw
NewLines_FileOutBasicSpecialChars.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 -Encoding UTF8;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment