Click here to Skip to main content
15,502,221 members
Home / Discussions / Database
   

Database

 
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 
QuestionRe: Update Database for C# application Pin
Nicholas Swandel21-Feb-14 4:55
Nicholas Swandel21-Feb-14 4:55 
AnswerRe: Update Database for C# application Pin
PDTUM21-Feb-14 6:50
PDTUM21-Feb-14 6:50 
GeneralRe: Update Database for C# application Pin
Nicholas Swandel21-Feb-14 7:20
Nicholas Swandel21-Feb-14 7:20 
Questionbegin tran in sql server 2008 Pin
vkEE19-Feb-14 6:22
vkEE19-Feb-14 6:22 
AnswerRe: begin tran in sql server 2008 Pin
GuyThiebaut19-Feb-14 7:02
professionalGuyThiebaut19-Feb-14 7:02 
GeneralRe: begin tran in sql server 2008 Pin
vkEE19-Feb-14 7:13
vkEE19-Feb-14 7:13 
GeneralRe: begin tran in sql server 2008 Pin
GuyThiebaut19-Feb-14 7:27
professionalGuyThiebaut19-Feb-14 7:27 
GeneralRe: begin tran in sql server 2008 Pin
vkEE19-Feb-14 7:43
vkEE19-Feb-14 7:43 
GeneralRe: begin tran in sql server 2008 Pin
GuyThiebaut19-Feb-14 8:32
professionalGuyThiebaut19-Feb-14 8:32 
GeneralRe: begin tran in sql server 2008 Pin
vkEE19-Feb-14 9:25
vkEE19-Feb-14 9:25 
GeneralRe: begin tran in sql server 2008 Pin
GuyThiebaut19-Feb-14 9:43
professionalGuyThiebaut19-Feb-14 9:43 
GeneralRe: begin tran in sql server 2008 Pin
Eddy Vluggen19-Feb-14 9:52
professionalEddy Vluggen19-Feb-14 9:52 
GeneralRe: begin tran in sql server 2008 Pin
Ananth A21-Feb-14 1:43
Ananth A21-Feb-14 1:43 
GeneralRe: begin tran in sql server 2008 Pin
GuyThiebaut21-Feb-14 1:56
professionalGuyThiebaut21-Feb-14 1:56 
GeneralRe: begin tran in sql server 2008 Pin
Eddy Vluggen19-Feb-14 9:25
professionalEddy Vluggen19-Feb-14 9:25 
GeneralRe: begin tran in sql server 2008 Pin
vkEE19-Feb-14 9:30
vkEE19-Feb-14 9:30 

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.