Posts
Sort by recent activity
Synonym not always resolving
Hi,In SQL-Prompt 10 (10.0.1.12389) when using a synonym the fields or the name of the synonym are not always resolved when there is no alias.Kind regards,Maurice
Synonyms wildcard not expanding
Hi,
I am using SQL Prompt 7.2.3.283 in management studio 2014 and I have the following issue.
Sometimes when using as select * from synonym (witch is based on a view in the other database) the wild...
Wild card not expanding synonym in 7.1.0.300
Hello,
In SQL Promt 7.1.0.300 is a synonym not expanding when the synonym name is in front of the wild card
SELECT [synonym].* FROM [dbo].[synonym]
Without the synonym the wild card is expanding j...
Prompt shows wrong fieldnames with EXCEPT or INTERSECT
When expanding a wildcard in a EXCEPT or INTERSECT query it shows the fields from the first SQL statement when you expect the field from the second statement.
SQLPrompt version 7.1.0.118CREATE TABL...
No suggestions table function without alias
Hi,
Just updated to SQL Prompt is 6.4.0.631 and found a feature
When I use a table function without an alias the columns as not showing in the where statement. It used to work without an alias, it...
SQL Prompt 6 EAP Synonym suggestion
If the option Qualify column names with table name is enabled and a select statement is made with a synonym, then when the asterisk is expanded the table name is not the synonym name but the name o...