639 results found
-
Intellisense for Linked Server connection to MySQL ODBC
I have been using SQL Prompt for awhile and one of the best feature I like about it is the fact that Intellisense works even on Linked Server to other MSSQL databases.
Recently however, I have set up Linked server to MySQL ODBC connections and I noticed that Intellisense is no longer returning the table names and column names in the predictive boxes.
I then tested this to other ODBC connection. I set up Firebird (DB2) and Oracle and Intellisense seems to be working for these (only for table names, not columns but that's better than nothing).
Is there a…
2 votes -
Improved Tab Navigation
Provide a better tab list for navigation than the one supplied by SSMS when there are many tabs open, for instance a resizable "navigation" window (or even a navigation tab) that easily allows filtering/grouping by server instance, database, user defined, etc.
As a complement to grouping tabs would be to allow naming, saving, closing, and opening of a "tab group" - related queries/script files that do not make up an SSMS "project" but are used for a particular purpose or go against a particular database, etc (user determines grouping criteria, see above). Furthermore, activating a tab group would bring its…
23 votes -
Replace all tabs with spaces
Setting the option to use spaces instead of tabs for intending (our house policy) only works for new tab presses.
I would like a simple action that would replace all tabs in the current document with spaces -- using the tab-to-spaces value as set in options. Sublime Text has this and I use practically every time I edit anything.57 votes -
15 votes
-
Smart Rename to change case
sometimes I need to just change the casing of letters in a field name (e.g. a field has GUID and I want to make it Guid). smart rename does not allow me to change the name if the new name is exactly the same saying that a column with this name already exists.
so I change the name to GuidXXXX and then on the generated script remove the XXXX and the script runs just fine.
I think smart rename should not warn that the name exists if I am just changing casing of the name
8 votes -
Dockable Summarize Script window that allows select/run of script blocks.
Summarize script is sort-of useful as a way to see script blocks easily, but it will be BRILLIANT if it was a dockable (not modal) window that you very quickly select the script blocks in the editor.
I often select parts of a script or subqueries to run - if Summarize Script automatically selected them for me it would be a huge productivity boost: 1-click selection + F5 = AWESOME!
42 votes -
Choose to have ALTER instead of CREATE scripts
When I hover over an object and get the pop-up script for that object (proc/view/function) I would like the ability to have the script default to ALTER instead of CREATE.
99.9% of the time I manually have to edit the Create to be an Alter, this would save SO MUCH time.
14 votes -
Search Results in Grid Mode
Find all occurrences of your search string in the results in datagrid mode. I know I should and could do this in SQL but sometime it is handle to find the customers name in a large set of rows.
19 votes -
Add Excel Like Gripd To Results Options
Add to the Results To options an Excel Like grid that presents the results i8n a grid but allows for Excel like functuionality without re-executing the query.
I often am sending my data (via copy & paste) to Excel for aditional reserahc because the query takes a long time to run and I alrady have the core data I needd, I just need to fin tune it bu re-sorting or even re-aggregating the data differently.
It wulod be a killer plus if Microsoft simply reaplced the existing SSMS Grid with a mini-version of Excel but since Thats not likely any…
8 votes -
convert SQL to a vbb (or c#) string statement
in toad you can get it to convert a SQL statement into a VB or C# statement. i.e. if you have
select * from atable
where a = 'FREE'this would be converted to
SQL = "select * from atable"
sql =sql & "where a = 'FREE'"this is then pasted into the clipboard
it can also do the reverse, have a chunk of VB code with a SQL statement, past it into the window, highlight it and it will try and convert it back to straight SQL (do not worry about variables added into the the vbcode, even toad…
8 votes -
Create CRUD
Create a Select/Update/Insert/Delete procedure by rightclick a table.
With option to select columns for each statement.
34 votes -
Convert code to dynamic Code
Convert selected CODE or a complete stored procedure to Dynamic SQL Code.
16 votes -
Organize objects in SSMS with a folder stucture
The reason I would like to see the folders is strictly for organizational purposes. I have so many procedures and tables in one database that I have to scroll through them all to find what I’m looking for. If I could organize by schema (or however I choose) and very quickly and jump back and forth between the different folders, that would help me out tremendously. The SQL filter function is so slow when going back and forth.
What if I could organize sql instances that I'm connected to in one SSMS. Production and Development folders?? Just another thought.
16 votes -
Template based formatting with different
Template based formatting.
Select your text and right click, format according to template... then select the appropriate template of your choice.8 votes -
11 votes
-
Auto generated INSERT needs a column blacklist
Add the ability to exclude columns from appearing in the auto-generated INSERT statements. I have to manually remove certain columns every time.
9 votes -
Please include support for Extended Events in SQL Prompt
Extended Events is a great feature in SQL Server. Without support for this in SQL Prompt makes it incomplete.
I know we have a GUI for it in SQL Server 2012. But it will quite sometime before everybody is on the latest version of SQL Server14 votes -
Change quote completion behavior within Openquery or dynamic SQL strings
I really like auto quote completion, but when I am working with an openquery statement or dynamic sql where I am having to escape quotes by doubling them up, I find myself fighting the "helpful" behavior of quote completion either refusing to add a second quote or it adds too many quotes.
So, my suggestion is that the quote completion feature check to see if you are trying to add quotes within a quoted string and change its behavior to either not do quote completion or to (even better) automatically add escaped quotes.To illustrate the problem and my proposed…
4 votes -
Visual indication on open transaction
Show a visual indication when open transactions exist in a query window (@@TRANCOUNT > 0)
It could be changing the background color of the query window, and a number in the status bar showing the current transaction depth or something like that.
32 votes -
Ability to Save invalid objects list instead of re-running entire database each time
When you are working with a rather large database it would be nice to be able to save a list of invalid objects to come back rather than having to re-run through the entire database again.
6 votes
- Don't see your idea?