309 results found
-
alias second table reference
Automatically alias a second reference to a table even if "generate alias on commit" is not enabled
4 votes -
Pivot Columnar / Vertical Tables to Tradiational Row-type tables
I have looked high and low for product that will meet a need that I often have; from the number of posts that I find on the net many others have as well.
More and more, with the increase in the amount of data being collected and queried, data warehouses, BI software, using columnar tables (sometimes referred to as a vertical data structure) makes more since. Vertica DB and Terri Data use this structure natively.
However, it often is necessary to convert (or pivot) the data to a traditional horizontal, row-based format. In SQL Server as well as Oracle, and…
12 votes -
Expand contect menu "Generate Script As" with an "As-Is" option.
This would enable easy execution of scripts generated by another script. Preferably with an extra "Execute in new tab" option.
I use this method very often to automate my DBA work. Now it's a 3-4 step procedure, this idea will make it into a one-step thing.0 votes -
I often find when writing queries that I want to see a sample of data from the table I'm working with. It would by good if I could right cli
I often find when writing queries in the SQL edior that I want to see a sample of data from the table I'm working with. It would by good if I could right click on the table name in the text editor and have a 'select top 100' option in the popup menu
0 votes -
If user types a paren *immediately before* a paren, skip *past* the paren instead
AutoComplete suggestion: MS Visual Studio does this, you should too.
- Type in a function name: SQLComplete adds a full set of parentheses: SET X=myFunction()
- Type in function parameters: SET x = MyFunction(1,2)
- If user types closing paren, we have two, which is wrong. Current alternative is to right arrow or something to get past it.
- SUGGESTION: If user types a paren immediately before a paren, skip past the paren instead!
MS Visual Studio does this and it works great.
0 votes -
Formatting option for BACKUP/RESTORE commands
I like BACKUP/RESTORE commands formatted so that all the options (especially MOVE options) are on separate lines in order to enhance readability.
0 votes -
Alias CTE like tables
When referencing a CTE, the CTE name is also its alias instead of the shortened version. E.g. the CTE NewUsers doesn't get aliased as "nu". Also, when typing "SELECT * FROM NewUsers", navigating to the "*" and hitting tab to expand columns, the expanded column names aren't prefixed with an alias or table name. This could just be a settings issue
0 votes -
Show intellisense for stored procs located in Master database
Currently, Sql Complete doesn't show intellisense for procs in Master DB when the active connection is in a different database. These procedures are still runnable from any database, so it should still show intellisense. This should be enabled by default or at least have an option in settings.
0 votes -
Support for ANSI-quoted identifiers
For example
SELECT * FROM "Person" WHERE "Person".0 votes
- Don't see your idea?