![]() ![]() You can use CTRL+SHIFT+V to paste the current item in Clipboard Ring’s memory. ‘Cycle Clipboard Ring’ feature in SSMS allows you to keep track of last 20 items you have cut/copy and reuse them without any need of copying and pasting text multiple times. The problem with pasting your copied contents using CTRL+V is that it only pastes the last copied text. Two shortcut keys which every developer use in their day to day work is CTRL+C and CTRL+V. Reuse your copied items by storing in memory For developers running data manipulation scripts, it’s always nice to have a visual indication of the environment you are logged in – especially a RED color in your SSMS query editor, indicating you to be extra cautious. Once you select a color for an environment, every time you login to that SQL Server instance – it will display the same color in the SSMS status bar. Then click on the ‘Connection Properties’ tab and you can choose a custom color for your environment: When you are connecting to a SQL Server instance, you will need to click on the ‘Options’ button: This presents a visual indication of the environment in which you are running your scripts. Hence when you connect with a particular environment, it uses the same assigned color. The color is displayed in the SSMS status bar, at the bottom. PROD – Red, MOCK – Orange, QA – Yellow, DEV – Blue and Local – Green Personally, I prefer to set the below colors for my environments. SSMS provides us with an ability to set different colors for connection to separate environments. Also, think about a scenario when you have a data manipulation script to be executed in different environments, isn’t it a big advantage to have a visual differentiation between the environments you are executing your scripts against? This often becomes unmanageable and difficult to keep track of. ![]() Use custom colors to differentiate between environmentsĭuring our day to day work in SSMS, generally we have to shift between different environments – Local/DEV/QA/MOCK/PROD, resulting in the creation of multiple query tabs – with each query tab connected to different environments. Increase your Coding Speed in SQL Server Management Studio.SQL Server Management Studio 2016 Productivity Enhancements.I would highly recommend you to go through my last 2 articles relating with SSMS Productivity, if you have not gone through it already – In this article, I will be sharing some beneficial Tips and Tricks which will give you an extra edge in your day to day work, and in the process take your productivity to the next level. G.I have been using SSMS for a long time now, and over the period of time I have realized that it’s a very powerful IDE – however, there are lots of hidden features which are less known to lots of developers. WHERE LastName IN ('Smith', 'Godfrey', 'Johnson') Finding rows that are in a list of values - Uses AdventureWorksDW WHERE EmployeeKey <= 500 AND LastName LIKE '%Smi%' AND FirstName LIKE '%A%' į. Finding rows that must meet several conditions - Uses AdventureWorksDW WHERE EmployeeKey = 1 OR EmployeeKey = 8 OR EmployeeKey = 12 Į. Finding rows that meet any of three conditions - Uses AdventureWorksDW Finding rows by using a comparison operator - Uses AdventureWorksDWĭ. Finding rows that contain a value as part of a string - Uses AdventureWorksDWĬ. Finding a row by using a simple equality - Uses AdventureWorksDWī. The following examples show how to use some common search conditions in the WHERE clause. ![]() For more information about search conditions and predicates, see Search Condition (Transact-SQL). There is no limit to the number of predicates that can be included in a search condition. Argumentsĭefines the condition to be met for the rows to be returned. To view Transact-SQL syntax for SQL Server 2014 and earlier, see Previous versions documentation. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |