268 results found
-
trigger order, we need a handy way to set or change trigger order
It is sometimes important to set triggers order when there are several triggers for a single table, UPDATE event, for example.
There is a command which performs this:
EXEC spsettriggerorder @triggername=N'[dbo].[tskTask_Validate]', @order=N'First', @stmttype=N'UPDATE'But I wish I had a visualized tool for this task and more control than a simple 'First' / 'Last' option.
Thank you
1 vote -
On the customer License Information page, add a user editable field where we can log who has which license.
I purchase the licenses for my dev team, so when I purchase two licenses, one for myself (SQL Tools) and a separate on for one of my devs (Schema Compare) I would like to indicate which is assigned to whom. Currently on the License information page, both appear assigned to me. While two folks is easy, if we grow our usage of your products further, I would like to know who I've assigned which licenses to, while keeping them all under the one account.
All I'm looking for is a field that I as the customer can note this type…
3 votes -
hotkeys
Please implement. Support of simple shortcuts for work with lines (that not implemented as well) like in notepad++ or Visual Studio or MSSMS. I mean such shortcuts and features as : Ctrl+D - duplicate line, Ctrl+L - remove line, Ctrl+J - join lines etc.
1 vote -
1 vote
-
1 vote
-
Python Generator to accept other table's columns
I have to generator a column based on another tables column value . Currently python generator can work with same table columns only. It will be great if we can access other table column also.
1 vote -
Data Compare: Drag & drop database backups
Drag & drop backups when comparing database backups.
See here: https://i.imgur.com/4yD2se0.png1 vote -
Output
Option for cleaning Output before every Execute of sql statement/script
3 votes -
option to calculate values based on other columns in data generator
(for example totalprice=unitprice+tax)
0 votes -
1 vote
-
Command to better see table and its dependencies on Database Diagram
It would be nice to have a command in the popup menu allowing to see the table along with its dependencies. I.e., to zoom it out in order to fit on the page and make the other tables transparent or something like that.
0 votes -
Search or Navigation in Database Diagram
It would be convenient to be able to search or navigate through the database diagram, similar to class navigation in Visual Studio.
0 votes -
option to generate data for updateable views
No option to generate data for updateable views
0 votes -
query shortcuts
Just like SSMS i'd like to use query shortcuts like
selecting a table
press ctrl+1
results is
SELECT COUNT(*) FROM {selected table}3 votes -
save custom filters in source control tool
I would reclaim many minutes a day if I could save my custom filters in the source control tool.
1 vote -
create custom folders to group connections in data explorer
It would be nice to be able to group connections to folders in Data Explorer.
Ablility to create folder structures in Data Explorer and move connections to different folder.17 votes -
Enable SQL Studio to work on Microsoft Azure SQL Data Warehouse and Analytics Platform System (APS)
Please enable SQL Studio features to work on Microsoft Azure SQL Data Warehouse and Analytics Platform (APS). Both APS and Azure SQL Data Warehouse have similar parallel DW architecture (MPP). Azure SQL Data Warehouse is the cloud version of on-prem APS appliance. We want a tool that can work with APS / Azure SQL Data Warehouse. Right now dbForge SQL Studio can connect to APS, but nothing works beyond that.
Azure SQL Data Warehouse: https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-overview-what-is
Microsoft Analytics Platform System (APS): https://www.microsoft.com/en-us/sql-server/analytics-platform-system
5 votes -
Add Test mode for SQL
I used to work with Apex SQL where there was test mode. This is a very simple, but convenient feature. There was a button "Test Mode" beside the "Execute Script" button. The button had two states - pressed and unpressed. Clicking the button added two rows. "BEGIN TRANSACTION" was added at the beginning of the script and "ROLLBACK TRANSACTION" was added at the end. When unpressing the button, the two rows disappeared.
2 votes -
Rows affected not be summed up
When you do an insert and it fires a trigger, the rows affected returned is a lump sum. In SSMS, each row affected is a separate output. So for example, you would get the number of rows the 1st trigger caused and the the actual inserted rows in the prime table. Same applied to update and delete actions.
3 votes -
Option to choose where New Sql tab will open
A new preference to indicate whether the New Sql tab should to the furthermost right or left. Sometimes when you're working things out, you want to see the tabs in the progression of when you built in or just to know that the latest work is way to the right or left
1 vote
- Don't see your idea?