![]() We will also create menu commands to execute global SQL statements. This example will be explained later with another screenshot and the explanation of the SQL\code behind it. In this example, I find all duplicate values within a certain column. For the column context menu, you are able to find duplicate values in that column.īelow you can see that I have added a new context menu option for columns only. You will also see logic that determines if a user has right clicked on a table or a column and display the appropriate context menu for that object. Download the Chinook SQL script ( SQLScript.zip)īelow is an example of the custom table context menu that the addin will create (Custom SQL & Script Full Schema).Visual Studio 2013 SDK (Addin project template).SQL Server 2012 installed (or Expression version).Visual Studio 13 installed (or Express version).Wouldn't it be so much easier to right click a table and get the row count or select a column and find the duplicate values in that table, or run generic common SQL statements against the Master database, all from mouse clicks instead of typing, cutting\pasting or loading a saved SQL query from file and executing it. So, instead of typing that "SELECT COUNT(*) FROM XYZ_Table", I decided to develop my own SSMS (12) custom addin, using Visual Studio 13. There has to be an easier way to speed up your SQL productivity. Like most DBA's I find myself repeating the same SQL statements over-and-over again.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |