Click here to Skip to main content
       

Database

 
GeneralRe: database PinmemberMycroft Holmes1-Mar-13 11:57 
QuestionRestrict user to delete database object in SQL SERVER 2005 PinmemberLTM_it_kh28-Feb-13 19:49 
AnswerRe: Restrict user to delete database object in SQL SERVER 2005 PinmvpEddy Vluggen1-Mar-13 5:01 
AnswerRe: Restrict user to delete database object in SQL SERVER 2005 Pinmembergvprabu2-Mar-13 1:56 
GeneralRe: Restrict user to delete database object in SQL SERVER 2005 PinmemberLTM_it_kh28-Mar-13 5:20 
QuestionHelp for RSA ...plzzz Pinmembershahbaz_llm28-Feb-13 7:19 
Questionsql server table records to sqlite Pinmemberjojoba201127-Feb-13 18:23 
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 
Try just running the select portion of it and see if you return results.
 
Your insert will need to use a field list though, not *. eg: insert into table1 (field1, field2) select field1, field2 from table2
 
Also, you would need to clear the data from your local table first if you are wanting to replace it with the data from your server.

QuestionRe: sql server table records to sqlite Pinmemberjojoba201128-Feb-13 2:40 
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 
QuestionSQL Server 2012 annoyance... Pinmember_Damian S_27-Feb-13 15:21 
AnswerRe: SQL Server 2012 annoyance... Pinmember_Damian S_27-Feb-13 19:27 
GeneralRe: SQL Server 2012 annoyance... PinmemberMycroft Holmes27-Feb-13 19:57 
GeneralRe: SQL Server 2012 annoyance... Pinmember_Damian S_27-Feb-13 20:06 
GeneralRe: SQL Server 2012 annoyance... PinmemberMycroft Holmes27-Feb-13 20:47 
QuestionWhat order to be followed while generating schema upgrade script? PinmemberMember 313707826-Feb-13 18:10 
AnswerRe: What order to be followed while generating schema upgrade script? PinmemberMycroft Holmes27-Feb-13 20:01 
GeneralRe: What order to be followed while generating schema upgrade script? PinmemberMember 313707827-Feb-13 21:40 
GeneralRe: What order to be followed while generating schema upgrade script? PinmemberMycroft Holmes27-Feb-13 22:15 
QuestionSQL weirdness when aliasing columns PinmemberGregory.Gadow22-Feb-13 11:19 
AnswerRe: SQL weirdness when aliasing columns Pinmembergvprabu22-Feb-13 18:18 
AnswerRe: SQL weirdness when aliasing columns PinmemberMycroft Holmes24-Feb-13 13:08 
GeneralRe: SQL weirdness when aliasing columns PinmemberGregory.Gadow28-Feb-13 9:09 
GeneralRe: SQL weirdness when aliasing columns PinmemberMycroft Holmes28-Feb-13 12:04 
GeneralRe: SQL weirdness when aliasing columns PinmemberGregory.Gadow1-Mar-13 5:10 
AnswerSolution PinmemberGregory.Gadow1-Mar-13 9:28 
GeneralRe: Solution PinmemberMycroft Holmes1-Mar-13 11:53 
QuestionDatabase PinmemberMember 961179522-Feb-13 8:52 

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