Click here to Skip to main content
11,719,185 members (82,947 online)
   

Database

 
GeneralRe: database Pin
Mycroft Holmes1-Mar-13 11:57
memberMycroft Holmes1-Mar-13 11:57 
QuestionRestrict user to delete database object in SQL SERVER 2005 Pin
LTM_it_kh28-Feb-13 19:49
memberLTM_it_kh28-Feb-13 19:49 
AnswerRe: Restrict user to delete database object in SQL SERVER 2005 Pin
Eddy Vluggen1-Mar-13 5:01
mvpEddy Vluggen1-Mar-13 5:01 
AnswerRe: Restrict user to delete database object in SQL SERVER 2005 Pin
gvprabu2-Mar-13 1:56
membergvprabu2-Mar-13 1:56 
GeneralRe: Restrict user to delete database object in SQL SERVER 2005 Pin
LTM_it_kh28-Mar-13 5:20
memberLTM_it_kh28-Mar-13 5:20 
QuestionHelp for RSA ...plzzz Pin
shahbaz_llm28-Feb-13 7:19
membershahbaz_llm28-Feb-13 7:19 
Questionsql server table records to sqlite Pin
jojoba201127-Feb-13 18:23
memberjojoba201127-Feb-13 18:23 
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 
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 Pin
jojoba201128-Feb-13 2:40
memberjojoba201128-Feb-13 2:40 
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 
QuestionSQL Server 2012 annoyance... Pin
_Damian S_27-Feb-13 15:21
member_Damian S_27-Feb-13 15:21 
AnswerRe: SQL Server 2012 annoyance... Pin
_Damian S_27-Feb-13 19:27
member_Damian S_27-Feb-13 19:27 
GeneralRe: SQL Server 2012 annoyance... Pin
Mycroft Holmes27-Feb-13 19:57
memberMycroft Holmes27-Feb-13 19:57 
GeneralRe: SQL Server 2012 annoyance... Pin
_Damian S_27-Feb-13 20:06
member_Damian S_27-Feb-13 20:06 
GeneralRe: SQL Server 2012 annoyance... Pin
Mycroft Holmes27-Feb-13 20:47
memberMycroft Holmes27-Feb-13 20:47 
QuestionWhat order to be followed while generating schema upgrade script? Pin
Member 313707826-Feb-13 18:10
memberMember 313707826-Feb-13 18:10 
AnswerRe: What order to be followed while generating schema upgrade script? Pin
Mycroft Holmes27-Feb-13 20:01
memberMycroft Holmes27-Feb-13 20:01 
GeneralRe: What order to be followed while generating schema upgrade script? Pin
Member 313707827-Feb-13 21:40
memberMember 313707827-Feb-13 21:40 
GeneralRe: What order to be followed while generating schema upgrade script? Pin
Mycroft Holmes27-Feb-13 22:15
memberMycroft Holmes27-Feb-13 22:15 
QuestionSQL weirdness when aliasing columns Pin
Gregory.Gadow22-Feb-13 11:19
memberGregory.Gadow22-Feb-13 11:19 
AnswerRe: SQL weirdness when aliasing columns Pin
gvprabu22-Feb-13 18:18
membergvprabu22-Feb-13 18:18 
AnswerRe: SQL weirdness when aliasing columns Pin
Mycroft Holmes24-Feb-13 13:08
memberMycroft Holmes24-Feb-13 13:08 
GeneralRe: SQL weirdness when aliasing columns Pin
Gregory.Gadow28-Feb-13 9:09
memberGregory.Gadow28-Feb-13 9:09 
GeneralRe: SQL weirdness when aliasing columns Pin
Mycroft Holmes28-Feb-13 12:04
memberMycroft Holmes28-Feb-13 12:04 
GeneralRe: SQL weirdness when aliasing columns Pin
Gregory.Gadow1-Mar-13 5:10
memberGregory.Gadow1-Mar-13 5:10 
AnswerSolution Pin
Gregory.Gadow1-Mar-13 9:28
memberGregory.Gadow1-Mar-13 9:28 
GeneralRe: Solution Pin
Mycroft Holmes1-Mar-13 11:53
memberMycroft Holmes1-Mar-13 11:53 
QuestionDatabase Pin
Member 961179522-Feb-13 8:52
memberMember 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
Web02 | 2.8.150901.1 | Last Updated 4 Sep 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid