Formatting SQL

Microsoft SQL ServerI create a fair amount of T-SQL in the form of selects, views and stored procedures. While I try to format my code to make it easy to use, I do encounter code from other people which is not very well formatted; and if you look at the stored procedures or views which ship with Microsoft Dynamics GP, they are generally formatted with all of the code on a single line.

There are a variety of ways of formatting SQL and I’m sure there are addins for SQL Server Management Studio; however, I often work on clients servers and can’t just install anything I want.

Therefore, a web based alternative is favourite and SQLFormat is the best one I have come across so far.

To use, simple paste your code into the big box and click the Format SQL button:

SQLFormat

You can even load a file should you wish.

I’m posting it here as a reminder to myself.

How To Install Microsoft SQL Server 2017: Install SQL Server Management Studio

Microsoft SQL ServerIn this short series of posts, I am going to be covering the installation of Microsoft SQL Server 2017; the installation process for this version is somewhat different to previous ones, in that SQL Server Management Studio and SQL Server Reporting Services have been separated out from the main installer.

The series index can be found here. I am not a SQL expert and this series of posts is intended only for use on demo or test environment and not production ones.

The next component to be installed, is SQL Server Management Studio (SSMS). This was the first of the components which Microsoft removed from the main installer. However, to install it, we can launch the download page from the Setup utility.

Once launched, click Installation and then select Install SQL Server Management Tools:

SQL Server Installation Center - Installation

Continue reading “How To Install Microsoft SQL Server 2017: Install SQL Server Management Studio”

SQL Server Management Studio Not Allowing Table Changes That Require A Table To Be Dropped

Microsoft SQL ServerI was doing some work with a custom table yesterday and at one point needed to make a change to the table layout via SQL Server Management Studio. However, when I tried, I got the below error message;

Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can

Continue reading “SQL Server Management Studio Not Allowing Table Changes That Require A Table To Be Dropped”