Click here to Skip to main content
15,885,546 members
Home / Discussions / Database
   

Database

 
GeneralRe: Remove a noise word in a SQL Server 2008 database Pin
Fernando A. Gomez F.13-Jun-12 5:06
Fernando A. Gomez F.13-Jun-12 5:06 
GeneralRe: Remove a noise word in a SQL Server 2008 database Pin
Eddy Vluggen13-Jun-12 5:48
professionalEddy Vluggen13-Jun-12 5:48 
AnswerRe: Remove a noise word in a SQL Server 2008 database Pin
Bernhard Hiller13-Jun-12 4:40
Bernhard Hiller13-Jun-12 4:40 
GeneralRe: Remove a noise word in a SQL Server 2008 database Pin
Fernando A. Gomez F.13-Jun-12 5:07
Fernando A. Gomez F.13-Jun-12 5:07 
GeneralRe: Remove a noise word in a SQL Server 2008 database Pin
Fernando A. Gomez F.13-Jun-12 5:08
Fernando A. Gomez F.13-Jun-12 5:08 
QuestionSQL Compound Primary Keys Pin
Kevin Marois12-Jun-12 11:36
professionalKevin Marois12-Jun-12 11:36 
AnswerRe: SQL Compound Primary Keys Pin
PIEBALDconsult12-Jun-12 16:45
mvePIEBALDconsult12-Jun-12 16:45 
GeneralRe: SQL Compound Primary Keys Pin
Kevin Marois12-Jun-12 18:13
professionalKevin Marois12-Jun-12 18:13 
PIEBALDconsult wrote:
You may need to rethink your whole application.
I mainly wonder why the
clients would be adding records to these tables.


What if the client doesn't have a network connection? Where would the store the data. This application cannot have down time in the event of a lost connection. So the app will have a local data store and update the server periodically.

So, since new records can be added in the client's DB, I need to make sure the PK's are unique.

Thanks
If it's not broken, fix it until it is

GeneralRe: SQL Compound Primary Keys Pin
PIEBALDconsult13-Jun-12 4:10
mvePIEBALDconsult13-Jun-12 4:10 
GeneralRe: SQL Compound Primary Keys Pin
Kevin Marois13-Jun-12 6:33
professionalKevin Marois13-Jun-12 6:33 
JokeRe: SQL Compound Primary Keys Pin
Eddy Vluggen13-Jun-12 1:21
professionalEddy Vluggen13-Jun-12 1:21 
AnswerRe: SQL Compound Primary Keys Pin
Jörgen Andersson12-Jun-12 21:56
professionalJörgen Andersson12-Jun-12 21:56 
GeneralRe: SQL Compound Primary Keys Pin
Kevin Marois13-Jun-12 6:34
professionalKevin Marois13-Jun-12 6:34 
AnswerRe: SQL Compound Primary Keys Pin
Eddy Vluggen13-Jun-12 1:19
professionalEddy Vluggen13-Jun-12 1:19 
AnswerMaybe look at Set IDENTITY_INSERT On/Off Pin
David Mujica13-Jun-12 2:56
David Mujica13-Jun-12 2:56 
QuestionAccessing Oracle database Pin
Dangermouse9912-Jun-12 3:37
Dangermouse9912-Jun-12 3:37 
AnswerRe: Accessing Oracle database Pin
Pete O'Hanlon12-Jun-12 3:49
mvePete O'Hanlon12-Jun-12 3:49 
GeneralRe: Accessing Oracle database Pin
Dangermouse9912-Jun-12 4:08
Dangermouse9912-Jun-12 4:08 
GeneralRe: Accessing Oracle database Pin
Pete O'Hanlon12-Jun-12 5:34
mvePete O'Hanlon12-Jun-12 5:34 
AnswerRe: Accessing Oracle database Pin
PIEBALDconsult12-Jun-12 7:49
mvePIEBALDconsult12-Jun-12 7:49 
AnswerRe: Accessing Oracle database Pin
Jörgen Andersson12-Jun-12 21:33
professionalJörgen Andersson12-Jun-12 21:33 
QuestionSQL Server (image) data type Pin
Midnight Ahri10-Jun-12 20:33
Midnight Ahri10-Jun-12 20:33 
AnswerRe: SQL Server (image) data type Pin
Eddy Vluggen11-Jun-12 0:07
professionalEddy Vluggen11-Jun-12 0:07 
QuestionMySQL Password Pin
Tom M3W10-Jun-12 4:09
Tom M3W10-Jun-12 4:09 
AnswerRe: MySQL Password Pin
Eddy Vluggen10-Jun-12 4:13
professionalEddy Vluggen10-Jun-12 4:13 

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.