Click here to Skip to main content
12,349,884 members (21,960 online)
   

Database

 
GeneralRe: rule of DataAdapter Pin
messages9-May-13 5:16
membermessages9-May-13 5:16 
Questiondifference between with and temp table in my two query Pin
mehdi.sabet7-May-13 9:02
groupmehdi.sabet7-May-13 9:02 
AnswerRe: difference between with and temp table in my two query Pin
Eddy Vluggen7-May-13 9:40
mvpEddy Vluggen7-May-13 9:40 
AnswerRe: difference between with and temp table in my two query Pin
Jörgen Andersson8-May-13 11:52
professionalJörgen Andersson8-May-13 11:52 
AnswerRe: difference between with and temp table in my two query Pin
Fabricio Dos Santos Antunes10-May-13 14:55
memberFabricio Dos Santos Antunes10-May-13 14:55 
QuestionExport Image from SQL to png Format Pin
mrfalk7-May-13 8:09
membermrfalk7-May-13 8:09 
AnswerRe: Export Image from SQL to png Format Pin
Eddy Vluggen7-May-13 9:52
mvpEddy Vluggen7-May-13 9:52 
QuestionBulk insert not recognizing end of file Pin
searching for solution.....5-May-13 23:18
membersearching for solution.....5-May-13 23:18 
AnswerRe: Bulk insert not recognizing end of file Pin
Eddy Vluggen6-May-13 7:56
mvpEddy Vluggen6-May-13 7:56 
QuestionHow to get data from Gridview (gridview(checkbox)) using asp.net and c#...... Pin
nukalarajesh1-May-13 21:19
groupnukalarajesh1-May-13 21:19 
AnswerRe: How to get data from Gridview (gridview(checkbox)) using asp.net and c#...... Pin
Richard MacCutchan1-May-13 21:27
mvpRichard MacCutchan1-May-13 21:27 
AnswerRe: How to get data from Gridview (gridview(checkbox)) using asp.net and c#...... Pin
AANIL DHAKAD8-May-13 3:17
memberAANIL DHAKAD8-May-13 3:17 
Questionhow to upload a iamge file on web server in mvc4 asp.net c# Pin
nukalarajesh1-May-13 21:06
groupnukalarajesh1-May-13 21:06 
QuestionSQL Server null date 01/01/1900 possible issue - a question Pin
GuyThiebaut1-May-13 5:51
memberGuyThiebaut1-May-13 5:51 
SQL Server will return a null date as 01/01/1900 if one castes a null string to a date.

Now the issue is that someone had the idea of populating dates with 01/01/1900 to signify a certain stage with a row(meaning that the date is not known but it is known that that stage has been reached).

I only realised yesterday that this could cause an issue if a query is written where a null string is compared to one of these dates.

Does anyone else have experience of this and any suggestions?
I am currently thinking of changing these 01/01/1900 dates to 01/01/1901 to remedy this potential problem.

Thanks
“That which can be asserted without evidence, can be dismissed without evidence.”
― Christopher Hitchens

AnswerRe: SQL Server null date 01/01/1900 possible issue - a question Pin
Richard Deeming1-May-13 6:04
professionalRichard Deeming1-May-13 6:04 
GeneralRe: SQL Server null date 01/01/1900 possible issue - a question Pin
Aner Bautista3-May-13 8:25
memberAner Bautista3-May-13 8:25 
GeneralRe: SQL Server null date 01/01/1900 possible issue - a question Pin
jschell3-May-13 11:24
memberjschell3-May-13 11:24 
AnswerRe: SQL Server null date 01/01/1900 possible issue - a question Pin
Eddy Vluggen1-May-13 6:37
mvpEddy Vluggen1-May-13 6:37 
AnswerRe: SQL Server null date 01/01/1900 possible issue - a question Pin
jschell1-May-13 8:28
memberjschell1-May-13 8:28 
GeneralRe: SQL Server null date 01/01/1900 possible issue - a question Pin
Richard Deeming1-May-13 8:43
professionalRichard Deeming1-May-13 8:43 
GeneralRe: SQL Server null date 01/01/1900 possible issue - a question Pin
GuyThiebaut1-May-13 9:19
memberGuyThiebaut1-May-13 9:19 
GeneralRe: SQL Server null date 01/01/1900 possible issue - a question Pin
jschell2-May-13 7:59
memberjschell2-May-13 7:59 
Questionhow to union some table in a while loop to a table Pin
mehdi.sabet1-May-13 3:49
groupmehdi.sabet1-May-13 3:49 
AnswerRe: how to union some table in a while loop to a table Pin
Richard Deeming1-May-13 3:57
professionalRichard Deeming1-May-13 3:57 
GeneralRe: how to union some table in a while loop to a table Pin
mehdi.sabet1-May-13 4:10
groupmehdi.sabet1-May-13 4:10 
GeneralRe: how to union some table in a while loop to a table Pin
GuyThiebaut1-May-13 4:31
memberGuyThiebaut1-May-13 4:31 
GeneralRe: how to union some table in a while loop to a table Pin
Richard Deeming1-May-13 4:33
professionalRichard Deeming1-May-13 4:33 
GeneralRe: how to union some table in a while loop to a table Pin
mehdi.sabet1-May-13 5:04
groupmehdi.sabet1-May-13 5:04 
AnswerRe: how to union some table in a while loop to a table Pin
djj551-May-13 4:20
memberdjj551-May-13 4:20 
GeneralRe: how to union some table in a while loop to a table Pin
mehdi.sabet1-May-13 4:26
groupmehdi.sabet1-May-13 4:26 
GeneralRe: how to union some table in a while loop to a table Pin
Eddy Vluggen1-May-13 4:59
mvpEddy Vluggen1-May-13 4:59 
QuestionSSE 2008 R2 Backup Strategy Pin
Richard.Berry10030-Apr-13 19:47
memberRichard.Berry10030-Apr-13 19:47 
AnswerRe: SSE 2008 R2 Backup Strategy Pin
GuyThiebaut30-Apr-13 21:56
memberGuyThiebaut30-Apr-13 21:56 
GeneralRe: SSE 2008 R2 Backup Strategy Pin
Richard.Berry10030-Apr-13 22:16
memberRichard.Berry10030-Apr-13 22:16 
GeneralRe: SSE 2008 R2 Backup Strategy Pin
GuyThiebaut30-Apr-13 22:43
memberGuyThiebaut30-Apr-13 22:43 
GeneralRe: SSE 2008 R2 Backup Strategy Pin
Richard.Berry10030-Apr-13 23:18
memberRichard.Berry10030-Apr-13 23:18 
GeneralRe: SSE 2008 R2 Backup Strategy Pin
GuyThiebaut30-Apr-13 23:34
memberGuyThiebaut30-Apr-13 23:34 
GeneralRe: SSE 2008 R2 Backup Strategy Pin
Richard.Berry1001-May-13 0:10
memberRichard.Berry1001-May-13 0:10 
QuestionGeneric column mapping Pin
Ravikiran72p30-Apr-13 1:57
memberRavikiran72p30-Apr-13 1:57 
AnswerRe: Generic column mapping Pin
Eddy Vluggen30-Apr-13 9:49
mvpEddy Vluggen30-Apr-13 9:49 
AnswerRe: Generic column mapping Pin
Mycroft Holmes30-Apr-13 13:56
professionalMycroft Holmes30-Apr-13 13:56 
AnswerRe: Generic column mapping Pin
GuyThiebaut30-Apr-13 21:49
memberGuyThiebaut30-Apr-13 21:49 
AnswerRe: Generic column mapping Pin
jschell1-May-13 8:34
memberjschell1-May-13 8:34 
QuestionMariaDB on Linux Pin
mbadi27-Apr-13 10:57
professionalmbadi27-Apr-13 10:57 
QuestionError on SQL server join Pin
developer life26-Apr-13 13:12
memberdeveloper life26-Apr-13 13:12 
AnswerRe: Error on SQL server join Pin
s_magus26-Apr-13 17:41
members_magus26-Apr-13 17:41 
AnswerRe: Error on SQL server join Pin
AANIL DHAKAD8-May-13 19:17
memberAANIL DHAKAD8-May-13 19:17 
QuestionSQL Server 2012 Express on Network - cannot see attached databases - can see Master, etc. Pin
PrissySC26-Apr-13 12:37
memberPrissySC26-Apr-13 12:37 
AnswerRe: SQL Server 2012 Express on Network - cannot see attached databases - can see Master, etc. Pin
Mycroft Holmes26-Apr-13 13:01
professionalMycroft Holmes26-Apr-13 13:01 
GeneralRe: SQL Server 2012 Express on Network - cannot see attached databases - can see Master, etc. Pin
PrissySC27-Apr-13 1:39
memberPrissySC27-Apr-13 1:39 

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.


Advertise | Privacy | Mobile
Web01 | 2.8.160621.1 | Last Updated 24 Jun 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid