Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Invoke-Sqlcmd -ServerInstance WIN-C4IECI7KUHJ -Database BDWebAna2012 -Query "SELECT [id],[contentNodeId],[versionId],[propertytypeid],[dataInt],[dataDate],[dataNvarchar],[dataNtext] FROM [BDWebAna2012].[dbo].[cmsPropertyData]" | Export-CSV -Path "C:\Users\Administrator\Documents\table.csv" -Encoding UTF8
- http://ask.webatall.com/sql-server/11992_how-to-export-data-as-csv-format-from-sql-server-using-sqlcmd.html
- https://msdn.microsoft.com/en-us/library/ms162773.aspx
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement