|
|
-
|
|
Code snippets is one of the very important feature that has been added in SQL Server 2012 SSMS, which greatly improves productivity. In SQL Server 2012, now you can create your own snippets and insert that snippets in your queries/stored procedures by u...
|
|
-
|
|
We often use some external tools to manage our task list, where we will add our tasks and will follow the tasks according to the task list. Now with SQL Server 2012, external tool is no longer required.
SQL Server 2012 provides task list, where we can ...
|
|
-
|
|
Often in presentations, there is requirement of increasing size of content in SSMS. Until now, we used to use some third party softwares. Now SQL Server 2012 provides an option to increase/decrease the size.
We can individually configure the font-size ...
|
|
-
|
|
Until SQL Server 2012, in SSMS, we were able to open only one query window. 2 or more query windows can't share the same screen. Only one query window can be visible on the screen.
Now SQL Server 2012 SSMS provides the option to open multiple query win...
|
|
-
|
|
The default font in the query editor has been changed to Consolas in SQL Server Denali. Before denali, default font was Courier New....
|
|
-
|
|
Before SQL Server 2012, SSMS already provided a feature to debug the queries. In SQL Server 2012, this has been enhanced more to provide more rich experience.
1. Conditional Hit breakpoints ? Break point will hit only when the specified condition met...
|
|
-
|
|
SQL Server 2012 SSMS has a new node “Sequences” in object explorer under Database-> programmability. This will allows you to create new sequences or update existing sequences by using GUI.
1. Go to Object Expolorer -> Expland database -> Programmabil...
|
|
-
|
|
Often in stored procedures/queries, we will use IF, BEGIN..END, WHILE statements. Now, In SQL Server 2012, SSMS provides an option “Surround with”, which simplifies in enclosing query statements with these blocks.
1. Right Click and choose “Surround w...
|
|
-
|
|
Few users are used to shortcuts in SSMS, where as users coming from Visual Studio background, might be used to certain shortcuts, which might be different from SSMS. Now for the users, who are used to Visual Studio, SQL Server 2012 allows to change the ...
|
|
-
|
|
Often we will copy various parts of a query window content to another query window. While copying we often switch between multiple windows. Now in SQL Server 2012, SSMS supports a new feature "Cycle Clipboard Ring", which allows us to access previously ...
|
|