Message
From
26/09/2016 11:49:13
To
26/09/2016 11:42:36
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Miscellaneous
Thread ID:
01641338
Message ID:
01641346
Views:
37
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:
>W/o exact error message we can keep guessing whole day :)
>
>>It could be that. But from what I remember (I was doing this on the customer server) the error was not pointing to the "nulls" or "defaults". I think I may have typed something incorrectly there. I am trying to get the customer to let me connect again so that I can make another attempt. Thank you.
>>
>>>Maybe some columns outside of the list do not allow nulls and don't have defaults?
>>>
And the syntax I used was:
insert into MyTable1( field1, field2, field3) select field1, field2, field3 from AnotherDb..MyTable2Do you see what is wrong with the above?
>W/o exact error message we can keep guessing whole day :)
>
>>It could be that. But from what I remember (I was doing this on the customer server) the error was not pointing to the "nulls" or "defaults". I think I may have typed something incorrectly there. I am trying to get the customer to let me connect again so that I can make another attempt. Thank you.
>>
>>>Maybe some columns outside of the list do not allow nulls and don't have defaults?
>>>
"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