Click here to Skip to main content
15,564,383 members
Home / Discussions / Database
   

Database

 
AnswerRe: Help required on Database Model Pin
Duncan Edwards Jones26-Feb-14 12:06
professionalDuncan Edwards Jones26-Feb-14 12:06 
Questionintricate date query sql Pin
Martin Niemandt19-Feb-14 23:07
Martin Niemandt19-Feb-14 23:07 
AnswerRe: intricate date query sql Pin
Richard MacCutchan19-Feb-14 23:19
mveRichard MacCutchan19-Feb-14 23:19 
GeneralRe: intricate date query sql Pin
Martin Niemandt19-Feb-14 23:28
Martin Niemandt19-Feb-14 23:28 
GeneralRe: intricate date query sql Pin
Richard MacCutchan20-Feb-14 0:08
mveRichard MacCutchan20-Feb-14 0:08 
GeneralRe: intricate date query sql Pin
Martin Niemandt20-Feb-14 1:11
Martin Niemandt20-Feb-14 1:11 
GeneralRe: intricate date query sql Pin
Richard MacCutchan20-Feb-14 1:16
mveRichard MacCutchan20-Feb-14 1:16 
GeneralRe: intricate date query sql Pin
Martin Niemandt20-Feb-14 1:24
Martin Niemandt20-Feb-14 1:24 
GeneralRe: intricate date query sql Pin
Richard MacCutchan20-Feb-14 1:29
mveRichard MacCutchan20-Feb-14 1:29 
GeneralRe: intricate date query sql Pin
Martin Niemandt20-Feb-14 1:41
Martin Niemandt20-Feb-14 1:41 
AnswerRe: intricate date query sql Pin
Mycroft Holmes20-Feb-14 13:01
professionalMycroft Holmes20-Feb-14 13:01 
GeneralRe: intricate date query sql Pin
Martin Niemandt20-Feb-14 19:53
Martin Niemandt20-Feb-14 19:53 
GeneralRe: intricate date query sql Pin
Mycroft Holmes20-Feb-14 20:46
professionalMycroft Holmes20-Feb-14 20:46 
GeneralRe: intricate date query sql Pin
Martin Niemandt20-Feb-14 21:45
Martin Niemandt20-Feb-14 21:45 
GeneralRe: intricate date query sql Pin
Mycroft Holmes20-Feb-14 22:36
professionalMycroft Holmes20-Feb-14 22:36 
GeneralRe: intricate date query sql Pin
Martin Niemandt20-Feb-14 23:01
Martin Niemandt20-Feb-14 23:01 
GeneralRe: intricate date query sql Pin
Jörgen Andersson20-Feb-14 22:28
professionalJörgen Andersson20-Feb-14 22:28 
GeneralRe: intricate date query sql Pin
Martin Niemandt20-Feb-14 23:04
Martin Niemandt20-Feb-14 23:04 
QuestionMSSQL : Selecting a value from a row that has a column with minimun creation time for given parameters Pin
Prasad A19-Feb-14 20:26
Prasad A19-Feb-14 20:26 
AnswerRe: MSSQL : Selecting a value from a row that has a column with minimun creation time for given parameters Pin
GuyThiebaut19-Feb-14 22:46
professionalGuyThiebaut19-Feb-14 22:46 
GeneralRe: MSSQL : Selecting a value from a row that has a column with minimun creation time for given parameters Pin
Prasad A19-Feb-14 23:08
Prasad A19-Feb-14 23:08 
GeneralRe: MSSQL : Selecting a value from a row that has a column with minimun creation time for given parameters Pin
GuyThiebaut19-Feb-14 23:24
professionalGuyThiebaut19-Feb-14 23:24 
QuestionUpdate Database for C# application Pin
PDTUM19-Feb-14 7:06
PDTUM19-Feb-14 7:06 
AnswerRe: Update Database for C# application Pin
David Mujica19-Feb-14 9:39
David Mujica19-Feb-14 9:39 
Whew, lots of questions here.

Let me suggest one item.

You should create a script that would methodically alter the necessary tables, columns etc and use that script to update your various clients.

Here is a reference to the ALTER TABLE command ...

http://msdn.microsoft.com/en-us/library/ms190273.aspx[^]

There are tools out there which compare 2 schemas and generate scripts which make the necessary changes. The idea is that you point it at database1 ver 1.0 and at database2 ver 2.0 and the tool will detect that there are new tables, new columns, etc.
AnswerRe: Update Database for C# application Pin
PDTUM20-Feb-14 6:54
PDTUM20-Feb-14 6:54 

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.