Press the Alt key on the keyboard and left click on the mouse, click and drag to select the desired block before columns, as you may notice a very light vertical blue line will appear, after that just type the latter a with the dot (.) and will be placed in front of the all columns:Ĭonverting SQL code to Upper or Lower case
To clarify, to add a table alias to columns in this case the a alias: The Delete Horizontal White Space removes all spaces for the selected SQL code:Īnother way to get rid of unnecessary white spaces is to hold the Alt key and left mouse click, select the block of white spaces:Īfter selecting press the Delete key to remove those spaces:Īlternately, with this type of selection, a text can be added multiple times at once. In a SQL editor, select the code and under the Advanced sub-menu of the Editor menu, choose the Delete Horizontal White Space command : Luckily, these white spaces can be easily removed using the Delete Horizontal White Space option. Whenever the data migration from any old systems to new/upgraded systems, using different formats like text files, csv, excel or some other format to insert data into SQL Server, the additional white spaces can be added, like in the example below: To see if spaces in a code are converted to tabs and vice versa, go to the Edit main and, under Advanced sub-menu, choose the View Whit Space command:įor example, if the Tabify Selected Lines command in the code to convert spaces in tabs is used, the following code:Īnd when the Untabify Selected Lines command is used to convert tabs into spaces, the SQL code will look like this: To convert spaces to tabs in SQL code and vice versa in a query editor, select the spaces that want to convert in tabs, go to the Edit menu and under the Advanced sub-menu, choose the Tabify Selected Lines command for converting white space to tabs and choose the Untabify Selected Lines command to convert tabs to spaces: The same options for Indent and unindent code are available under the Advanced sub-menu of the Edit menu: To indent SQL code, in a query editor, select the code that wants to indent and press the Tab key from the keyboard or, from the SQL Editor toolbar, press the Indent button:įor unindenting code press the Shift+Tab keys or use the Unindent button from the SQL Editor toolbar: Under the Tab size and Indent size boxes, enter the number of space characters, each tab or indent represents:
If tab characters for indent and tab operations is needed, select the Keep tabs radio button:īut if want to use space characters for indent and tab operations, choose the Insert spaces radio button: In the Tabs tab, it can be specified how many spaces compose a single indentation or tab, and whether the Editor uses tabs or space characters when indenting.
It determines the appropriate indenting style to use. When this option is selected, in a query editor, when press the enter key, the cursor aligns the next line with the previous line:īy default, this option is used. When this option is selected, in a query editor, when the enter key from the keyboard is pressed, the cursor goes to the beginning of the next line: In the Options window, click the Text Editor tab and under the All Languages sub-tab, select the Tabs tab: To select desired indenting options, go to the SSMS Tools menu and, from the context menu, choose the Options command: In SQL Server, three are three options for indenting of SQL code. So, let’s first start with SQL formatter options to format code and then ApexSQL Refactor add-in to do the same thing and more. This article will guide you through some SQL formatter options via SSMS and using 3 rd party SQL formatting tool such is ApexSQL Refactor to format code. It’s the SQL formatter that makes the difference.Īll SQL code can be formatted manually, which is very time consuming but 3 rd party SQL formatter tools do exist and can be used to help formatting quickly and efficiently.
#VISUAL STUDIO 2017 SQL SERVER CE TUTORIAL HOW TO#
How to make code readable so that it is enough just to skim through the code and get the general idea. A clean SQL can be read faster than an inconsistently written SQL SQL reviewing and troubleshooting are more efficient joint development efforts are more effective handing off projects from one team to another is easier. It can make code difficult to unscramble and understand. SQL code can have different SQL formatting styles, which could make a job either easier or more difficult. When reading SQL script where there is a large amount of non-formatted SQL code, the problem becomes even bigger. Nobody likes to read a large amount of text, even when it’s just a plain one. This article will provide a review of SQL code formatting using the SQL formatter options in SSMS
0 kommentar(er)
