Configurable Header Text Template, with quick insert, so you can easily sign you codes. Quick encapsulate code in region. Other versions: https://sourceforge.net/projects/michelmaxssmstools2012/ https://sourceforge.net/projects/michelmaxssmstools2014/ ...
Linked servers Creating a linked server to Azure SQL Database with SQL Server selected as Server type connects to the master database. To create a linked server to Azure SQL Database, select Other data source for the Server type, and select Microsoft OLE DB Provider for SQL Server or Micros...
You can also manage formatting templates underSSMSBoost->Settings->Formatting. Here you can find import/export option that allows you to share templates with your colleagues. "Poor Man's T-SQL Formatter" This formatter is added as an external tool which SSMSBoost calls in the background. The ...
Add a carriage return in a .csv file Add a Property to an Array that Adds a Range of IPs Add a URL rewrite condition on IIS using Powershell Add Array Items to Listbox Add blank column to csv with no header? Add column to text file Add columns to PowerShell array and write the r...
Basic - select with fixed values - invert columns to rows Basic CTE query, get full path of something recursive BCP Error - Copy direction must be either 'in', 'out' or 'format'. BCP Export to csv using UTF-8 or UTF-16 BCP Issue when using a format file and excluding columns. B...
Worst case I can deal with a single output that I need to filter but eventually this query will be updated to generate up to ~ 40 result sets on each run so it would be very tedious to have to manually separate that afterwards. sql sql-server excel ssms export-to-csv...
New: Script selected cells asWHERE clause conditionsper row. New: Script selected cells tocustom formatwith settable header and data, row and column separators. SQL Editor Plus New:Rename tab to first regular expression matchin the first N lines of the script. ...
CSV export - pipe delimited with double quotes when opening in Excel CSV Export Double Quotes Current date minus 365 daqys Current week as default week in the SSRS report Current Year expression in SSRS 2008 custom code funct...
Linked servers Creating a linked server to Azure SQL Database with SQL Server selected as Server type connects to the master database. To create a linked server to Azure SQL Database, select Other data source for the Server type, and select Microsoft OLE DB Provider for SQL Server or Micros...
The same query run in SQL Server 2012 produces some records that have a line break in the middle of the record. There are no line breaks or quotes in any fields in the record. It also happens if we save the results as a .CSV file.Is this a bug in SQL 2012?