Click here to Skip to main content
15,566,691 members
Home / Discussions / Database
   

Database

 
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 
Mycroft and Richard are completely correct in that you should never store duplicated data.

But theres a way to automize it, on SQLServer it's called a Computed Column[^] and if you're using Oracle it's a Virtual Column[^].
The best part is that you can put an index on them.
Wrong is evil and must be defeated.
- Jeff Ello[^]

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 
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 

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.