Click here to Skip to main content
       

Database

 
AnswerRe: sql server table records to sqlite Pinmember_Damian S_27-Feb-13 18:35 
QuestionRe: sql server table records to sqlite Pinmemberjojoba201127-Feb-13 18:40 
AnswerRe: sql server table records to sqlite Pinmember_Damian S_27-Feb-13 18:51 
QuestionRe: sql server table records to sqlite Pinmemberjojoba201127-Feb-13 18:55 
AnswerRe: sql server table records to sqlite Pinmember_Damian S_27-Feb-13 19:05 
QuestionRe: sql server table records to sqlite Pinmemberjojoba201127-Feb-13 19:08 
AnswerRe: sql server table records to sqlite Pinmember_Damian S_27-Feb-13 19:15 
QuestionRe: sql server table records to sqlite Pinmemberjojoba201128-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 PinmvpEddy Vluggen28-Feb-13 9:25 
QuestionRe: sql server table records to sqlite Pinmemberjojoba20111-Mar-13 20:23 
AnswerRe: sql server table records to sqlite PinmemberMycroft Holmes27-Feb-13 18:50 
QuestionRe: sql server table records to sqlite Pinmemberjojoba201127-Feb-13 18:55 
AnswerRe: sql server table records to sqlite PinmemberMycroft Holmes27-Feb-13 19:28 
GeneralRe: sql server table records to sqlite Pinmemberjojoba201127-Feb-13 19:43 
GeneralRe: sql server table records to sqlite PinmemberMycroft Holmes27-Feb-13 19:51 
QuestionRe: sql server table records to sqlite Pinmemberjojoba201128-Feb-13 2:41 
AnswerRe: sql server table records to sqlite PinmemberMycroft Holmes28-Feb-13 11:34 
Questionsql server 2008 query, Pinmembergavindon27-Feb-13 15:57 
AnswerRe: sql server 2008 query, Pinmember_Damian S_27-Feb-13 16:11 
GeneralRe: sql server 2008 query, Pinmembergavindon27-Feb-13 17:14 
GeneralRe: sql server 2008 query, Pinmember_Damian S_27-Feb-13 17:34 
AnswerRe: sql server 2008 query, PinmemberMycroft Holmes27-Feb-13 18:45 
GeneralRe: sql server 2008 query, Pinmember_Damian S_27-Feb-13 18:53 
GeneralRe: sql server 2008 query, PinmemberMycroft Holmes27-Feb-13 19:26 
AnswerRe: sql server 2008 query, Pinmembergvprabu28-Feb-13 21:28 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    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.140721.1 | Last Updated 23 Jul 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid