Message
From
26/09/2016 11:57:15
To
26/09/2016 11:53:16
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Miscellaneous
Thread ID:
01641338
Message ID:
01641349
Views:
29
>>I forgot to mention something important (here in the initial message). I am copying record from a table of one database to a table in another.
>>
>>And the syntax I used was:
>>
>>
>>Do you see what is wrong with the above?
>
>
>Dmitry....what is the error message?
>
>Note that sometimes you can get the red squiggly underline because of the intellisense cache
>
>So again...what is the error message you're getting?
The error is that the AnotherDb..MyTable2 is invalid object. And the column names have squiggly underline.
>>
>>And the syntax I used was:
>>
>>
>>insert into MyTable1( field1, field2, field3) select field1, field2, field3 from AnotherDb..MyTable2 >>>>
>>Do you see what is wrong with the above?
>
>
>Dmitry....what is the error message?
>
>Note that sometimes you can get the red squiggly underline because of the intellisense cache
>
>So again...what is the error message you're getting?
The error is that the AnotherDb..MyTable2 is invalid object. And the column names have squiggly underline.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham