Click here to Skip to main content
12,634,982 members (32,855 online)
   

Database

 
AnswerRe: sql server table records to sqlite Pin
Mycroft Holmes27-Feb-13 20:28
memberMycroft Holmes27-Feb-13 20:28 
GeneralRe: sql server table records to sqlite Pin
jojoba201127-Feb-13 20:43
memberjojoba201127-Feb-13 20:43 
GeneralRe: sql server table records to sqlite Pin
Mycroft Holmes27-Feb-13 20:51
memberMycroft Holmes27-Feb-13 20:51 
QuestionRe: sql server table records to sqlite Pin
jojoba201128-Feb-13 3:41
memberjojoba201128-Feb-13 3:41 
i got this code :
but cannot run for SQLite :

i get this error in sqlite :

<code>SQLite error near "INTO" : syntax error </code>


<pre lang="sql">cmd.CommandText = @&quot;SELECT top(5)  IdAmlak, ParentId, NameOpp, Price, [Square],
       OstanShahrMantagha, PhoneAddress, CountAmount
    INTO Melk
FROM      OPENDATASOURCE(
         &#39;SQLOLEDB&#39;,
         &#39;Data Source=217.66.216.77,1633;User ID=tinadbuser;Password=dbtin123ir&#39;
                 ).[CRM-CMS].dbo.tblTesting&quot;;</pre>

AnswerRe: sql server table records to sqlite Pin
Mycroft Holmes28-Feb-13 12:34
memberMycroft Holmes28-Feb-13 12:34 
Questionsql server 2008 query, Pin
gavindon27-Feb-13 16:57
membergavindon27-Feb-13 16:57 
AnswerRe: sql server 2008 query, Pin
_Damian S_27-Feb-13 17:11
member_Damian S_27-Feb-13 17:11 
GeneralRe: sql server 2008 query, Pin
gavindon27-Feb-13 18:14
membergavindon27-Feb-13 18:14 
GeneralRe: sql server 2008 query, Pin
_Damian S_27-Feb-13 18:34
member_Damian S_27-Feb-13 18:34 
AnswerRe: sql server 2008 query, Pin
Mycroft Holmes27-Feb-13 19:45
memberMycroft Holmes27-Feb-13 19:45 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web02 | 2.8.161208.2 | Last Updated 9 Dec 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid