Select statement like this
SELECT * FROM [dbo].[Narocila] AS n
INNER JOIN [dbo].[narocila_poz] ON
I need field n.NarocId from table 'Narocila' alias 'n'.
But, if I type 'n' I get candidate list starting with nValue, int, mySysConf, when I typing further newer get the proper table or field, 'nar' give me a stored procedure begin with nar, not column name or table name.
My opinion is.
If I have relationships between table Narocila and [Narocila Poz]. When I type INNER JOIN .... ON and press SPACE must give candidate list with relationships definition like in older version a SQL Prompt.
Naturally SQL Prompt don't know how I want to join table, but if I have primary and foreign key in tables whose use in SELECT statement, SQL Prompt must give me on chose in candidate list.
Regards
Uros
But, if I type 'n' I get candidate list starting with nValue, int, mySysConf, when I typing further newer get the proper table or field, 'nar' give me a stored procedure begin with nar, not column name or table name.
My opinion is.
If I have relationships between table Narocila and [Narocila Poz]. When I type INNER JOIN .... ON and press SPACE must give candidate list with relationships definition like in older version a SQL Prompt.
Naturally SQL Prompt don't know how I want to join table, but if I have primary and foreign key in tables whose use in SELECT statement, SQL Prompt must give me on chose in candidate list.
Regards
Uros