Dear All,
I would like to ask about autocomplete columns name:
I am using two different table_catalogues and table_schemas
And I have interesting observation:
When the query contains
select top 100 *
from table_name_1 f_cash
left join table_catalogues.tabel_name_2 m_med on m_med.column_i_name = f_cash.column_i_name
where 1 = 1
and m_med.
the auto-complete works perfectly
but when I want to run the query I get the Error
/* SQL Error (208): Invalid object name 'table_catalogues.tabel_name_2'. */
query works for:
select top 100 *
from table_name_1 f_cash
left join table_catalogues.table_schemas.tabel_name_2 m_med on m_med.column_i_name = f_cash.column_i_name
where 1 = 1
and m_med.
But auto-complete column name does not work. Do you have any idea why?
Ps.table_schemas is just Analyst name and every analyst has his own table schema.
And second question:
Is it possible to format the date before the grid export?
The issue I have concerns dates.
Example :In HeidiSql the date I see is: "2015-02-02 14:55:39.000" but after Clipboard export to Excel I see only "55:39.0" so MI:SS.D - Do you think this is Excel or grid export issue?
Thanks in advance.
Auto-complete columns names and data expot
ansgar Thanks for answer.
But why when I specified also the schema name the auto-completion doesn't work?
In fact I still don't know what are the circumstances when auto-completion works and when doesn't.
Are you able to tell me what should be the correct syntax for auto-completion when I query different table_catalogues?
And what about the second question - the answer is trivial - this is excel, or I can format the grid?
But why when I specified also the schema name the auto-completion doesn't work?
In fact I still don't know what are the circumstances when auto-completion works and when doesn't.
Are you able to tell me what should be the correct syntax for auto-completion when I query different table_catalogues?
And what about the second question - the answer is trivial - this is excel, or I can format the grid?
And another question, is there any possibility to turn-on highlighting line which contains the error? (or just through the reference)
Right now it is hard to check all "near ','"s
/* SQL Error (102): Incorrect syntax near the keyword 'as' Incorrect syntax near ','. */
Right now it is hard to check all "near ','"s
/* SQL Error (102): Incorrect syntax near the keyword 'as' Incorrect syntax near ','. */
Please login to leave a reply, or register at first.