Click here to Skip to main content
15,880,972 members
Home / Discussions / C#
   

C#

 
AnswerRe: c# windows application Working with Microsoft Office Word Pin
pkfox6-Jun-21 22:46
professionalpkfox6-Jun-21 22:46 
QuestionHow do you write a query for comparing SQL Server CE data? Pin
Alex Dunlop4-Jun-21 6:52
Alex Dunlop4-Jun-21 6:52 
AnswerRe: How do you write a query for comparing SQL Server CE data? Pin
Gerry Schmitz4-Jun-21 7:12
mveGerry Schmitz4-Jun-21 7:12 
GeneralRe: How do you write a query for comparing SQL Server CE data? Pin
Alex Dunlop4-Jun-21 7:25
Alex Dunlop4-Jun-21 7:25 
GeneralRe: How do you write a query for comparing SQL Server CE data? Pin
Gerry Schmitz4-Jun-21 8:10
mveGerry Schmitz4-Jun-21 8:10 
AnswerRe: How do you write a query for comparing SQL Server CE data? Pin
RedDk4-Jun-21 7:28
RedDk4-Jun-21 7:28 
GeneralRe: How do you write a query for comparing SQL Server CE data? Pin
Alex Dunlop4-Jun-21 7:36
Alex Dunlop4-Jun-21 7:36 
AnswerRe: How do you write a query for comparing SQL Server CE data? Pin
Alex Dunlop4-Jun-21 20:37
Alex Dunlop4-Jun-21 20:37 
Can anyone please check this SQL CE query and revise its syntax for me?
C#
insert into MyData values('test01', '1122/035', '666','ty01', 'tt01') where not exists (select * from MyData where 'test01', '1122/035', '666','ty01', 'tt01')

In query above, I add a new row to SQL data but it checks for duplicates before adding.

modified 5-Jun-21 2:45am.

GeneralRe: How do you write a query for comparing SQL Server CE data? Pin
Dave Kreskowiak5-Jun-21 4:42
mveDave Kreskowiak5-Jun-21 4:42 
GeneralRe: How do you write a query for comparing SQL Server CE data? Pin
Gerry Schmitz5-Jun-21 8:33
mveGerry Schmitz5-Jun-21 8:33 
QuestionWhat is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Alex Dunlop2-Jun-21 6:58
Alex Dunlop2-Jun-21 6:58 
AnswerRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Dave Kreskowiak2-Jun-21 7:08
mveDave Kreskowiak2-Jun-21 7:08 
GeneralRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Alex Dunlop2-Jun-21 7:13
Alex Dunlop2-Jun-21 7:13 
GeneralRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Victor Nijegorodov2-Jun-21 7:48
Victor Nijegorodov2-Jun-21 7:48 
GeneralRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Dave Kreskowiak2-Jun-21 7:50
mveDave Kreskowiak2-Jun-21 7:50 
GeneralRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Gerry Schmitz2-Jun-21 8:07
mveGerry Schmitz2-Jun-21 8:07 
AnswerRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Alex Dunlop2-Jun-21 7:12
Alex Dunlop2-Jun-21 7:12 
GeneralRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Dave Kreskowiak2-Jun-21 7:22
mveDave Kreskowiak2-Jun-21 7:22 
GeneralRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Alex Dunlop2-Jun-21 7:34
Alex Dunlop2-Jun-21 7:34 
GeneralRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Dave Kreskowiak2-Jun-21 7:43
mveDave Kreskowiak2-Jun-21 7:43 
GeneralRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Alex Dunlop2-Jun-21 7:48
Alex Dunlop2-Jun-21 7:48 
GeneralRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Dave Kreskowiak2-Jun-21 7:51
mveDave Kreskowiak2-Jun-21 7:51 
GeneralRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Gerry Schmitz2-Jun-21 8:00
mveGerry Schmitz2-Jun-21 8:00 
GeneralRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Dave Kreskowiak2-Jun-21 8:02
mveDave Kreskowiak2-Jun-21 8:02 
GeneralRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Gerry Schmitz2-Jun-21 8:09
mveGerry Schmitz2-Jun-21 8:09 

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.