SQL Server - How to compress and unzip files and directories using 7-zip and xp_cmdshell or SQLCLR (C #) June 10st, 2018 1 Database C # (CSharp) CLR Integrations File Handling SQL Server SQLCLR
SQL Server - File Operations Using xp_cmdshell (Listing, Reading, Writing, Copying, Deleting, and Moving Files) August 29st, 2017 2 Database File Handling SQL Server
SQL Server - How to export and import tabular data files (Ex: CSV) using CLR (C #) March 20th, 2017 2 Database C # (CSharp) CLR JSON, XML, CSV and Excel File Handling SQL Server
SQL Server - How to integrate with FTP and list, upload, and download files using CLR (C #) November 6th, 2016 3 Database C # (CSharp) CLR Integrations File Handling Programme SQL Server
SQL Server - How to Run PowerShell and Prompt-DOS (MS-DOS) Scripts Using CLR (C #) September 11th, 2016 0 Database CLR Hacks Integrations File Handling Powershell / CMD SQL Server
SQL Server - How to export the source code of all Stored Procedures, Functions, Views and Triggers from a database to .sql files August 25st, 2016 1 Database Integrations File Handling SQL Server
SQL Server - How to read, import, and export data from XML files June 18st, 2016 10 Database Query Development JSON, XML, CSV and Excel File Handling SQL Server
SQL Server - Importing and Exporting data from Excel spreadsheets June 14st, 2016 2 Database Query Development JSON, XML, CSV and Excel File Handling SQL Server
SQL Server - How to export database data to text file (CLR, OLE, BCP) June 2st, 2016 9 Database CLR Query Development File Handling OLE Automation SQL Server
SQL Server - How to import text files into database (OLE Automation, CLR, BCP, BULK INSERT, OPENROWSET) 29 May 2016 0 Database CLR Query Development File Handling OLE Automation SQL Server