Settings and activity
4 results found
-
15 votes
An error occurred while saving the comment An error occurred while saving the comment Eric Isaacs commented
This would be extremely helpful for me. This feature doesn't have to be an automatic format option (which I could see as a challenge.) It could simply be an option in the "Action List" that you can run on the selected code only.
is feature would be a huge time saver. I use automatic aliases for the code I write and it works great, but for existing code, we need a feature that would append the aliases even if it just appended the current table names.
EX: FROM dbo.TableName1 AS TableName1From there it's easy enough to use F2 to rename the tables.
But an even better feature would be to use the default configured alias names
EX: FROM dbo.TableName1 AS tn1.Either of those options or both would be a huge improvement.
Having both these options in the action list would be cool because there are times when one or the other is applicable to existing code, but having it configurable in options is also reasonable as to which type of aliasing would be preferred for each user/case.
-
9 votes
-
2 votes
-
4 votes
If we could select an unaliased table and click F2 at that point, it would be great if SQL Prompt could create the alias at that point.
For a query like this below, clicking on the table name anywhere it's referenced and clicking F2 should 1) create the alias and 2) allow it to be named at that point.
SELECT
Product.ProductID,
Product.ProductName,
Category.CategoryName,
CategoryGroup.CatergoryGroupName
FROM
dbo.Product
INNER JOIN dbo.Category ON Category.CategoryID = Product.CategoryID
INNER JOIN dbo.CategoryGroup ON CategoryGroup.CategoryGroupId = Category.CategoryGroupId
WHERE
Product.ProductId = 123456;
Right now the only way to create an alias for this type of existing SQL is to copy the table name, add AS table name next to the table, then use F2 on the new alias to rename the tables. It's cumbersome and slow for a query with multiple tables. Making it so that we can just click F2 on each table name would be so much easier and I assume it's much easier to implement in SQL Prompt than other options.