Click here to Skip to main content
12,512,515 members (66,464 online)
   

Database

 
AnswerRe: sql server table records to sqlite Pin
_Damian S_27-Feb-13 18:35
member_Damian S_27-Feb-13 18:35 
QuestionRe: sql server table records to sqlite Pin
jojoba201127-Feb-13 18:40
memberjojoba201127-Feb-13 18:40 
AnswerRe: sql server table records to sqlite Pin
_Damian S_27-Feb-13 18:51
member_Damian S_27-Feb-13 18:51 
QuestionRe: sql server table records to sqlite Pin
jojoba201127-Feb-13 18:55
memberjojoba201127-Feb-13 18:55 
AnswerRe: sql server table records to sqlite Pin
_Damian S_27-Feb-13 19:05
member_Damian S_27-Feb-13 19:05 
QuestionRe: sql server table records to sqlite Pin
jojoba201127-Feb-13 19:08
memberjojoba201127-Feb-13 19:08 
AnswerRe: sql server table records to sqlite Pin
_Damian S_27-Feb-13 19:15
member_Damian S_27-Feb-13 19:15 
QuestionRe: sql server table records to sqlite Pin
jojoba201128-Feb-13 2:40
memberjojoba201128-Feb-13 2:40 
i got this code :
but cannot run for SQLite :

i get this error in sqlite :

SQLite error near "INTO" : syntax error


cmd.CommandText = @"SELECT top(5)  IdAmlak, ParentId, NameOpp, Price, [Square],
       OstanShahrMantagha, PhoneAddress, CountAmount
    INTO Melk
FROM      OPENDATASOURCE(
         'SQLOLEDB',
         'Data Source=217.66.216.77,1633;User ID=tinadbuser;Password=dbtin123ir'
                 ).[CRM-CMS].dbo.tblTesting";

AnswerRe: sql server table records to sqlite Pin
Eddy Vluggen28-Feb-13 9:25
mvpEddy Vluggen28-Feb-13 9:25 
QuestionRe: sql server table records to sqlite Pin
jojoba20111-Mar-13 20:23
memberjojoba20111-Mar-13 20:23 
AnswerRe: sql server table records to sqlite Pin
Mycroft Holmes27-Feb-13 18:50
memberMycroft Holmes27-Feb-13 18:50 
QuestionRe: sql server table records to sqlite Pin
jojoba201127-Feb-13 18:55
memberjojoba201127-Feb-13 18:55 
AnswerRe: sql server table records to sqlite Pin
Mycroft Holmes27-Feb-13 19:28
memberMycroft Holmes27-Feb-13 19:28 
GeneralRe: sql server table records to sqlite Pin
jojoba201127-Feb-13 19:43
memberjojoba201127-Feb-13 19:43 
GeneralRe: sql server table records to sqlite Pin
Mycroft Holmes27-Feb-13 19:51
memberMycroft Holmes27-Feb-13 19:51 
QuestionRe: sql server table records to sqlite Pin
jojoba201128-Feb-13 2:41
memberjojoba201128-Feb-13 2:41 
AnswerRe: sql server table records to sqlite Pin
Mycroft Holmes28-Feb-13 11:34
memberMycroft Holmes28-Feb-13 11:34 
Questionsql server 2008 query, Pin
gavindon27-Feb-13 15:57
membergavindon27-Feb-13 15:57 
AnswerRe: sql server 2008 query, Pin
_Damian S_27-Feb-13 16:11
member_Damian S_27-Feb-13 16:11 
GeneralRe: sql server 2008 query, Pin
gavindon27-Feb-13 17:14
membergavindon27-Feb-13 17:14 
GeneralRe: sql server 2008 query, Pin
_Damian S_27-Feb-13 17:34
member_Damian S_27-Feb-13 17:34 
AnswerRe: sql server 2008 query, Pin
Mycroft Holmes27-Feb-13 18:45
memberMycroft Holmes27-Feb-13 18:45 
GeneralRe: sql server 2008 query, Pin
_Damian S_27-Feb-13 18:53
member_Damian S_27-Feb-13 18:53 
GeneralRe: sql server 2008 query, Pin
Mycroft Holmes27-Feb-13 19:26
memberMycroft Holmes27-Feb-13 19:26 
AnswerRe: sql server 2008 query, Pin
gvprabu28-Feb-13 21:28
membergvprabu28-Feb-13 21:28 

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
Web01 | 2.8.160929.1 | Last Updated 1 Oct 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid