Click here to Skip to main content
15,439,832 members
Home / Discussions / Database
   

Database

 
AnswerRe: Connecting DB tables Pin
Eddy Vluggen12-Nov-21 12:02
professionalEddy Vluggen12-Nov-21 12:02 
QuestionHow much difference is there between SQL server 2008 and 2012 Pin
jkirkerx28-Oct-21 9:09
professionaljkirkerx28-Oct-21 9:09 
AnswerRe: How much difference is there between SQL server 2008 and 2012 Pin
phil.o28-Oct-21 9:35
mvephil.o28-Oct-21 9:35 
GeneralRe: How much difference is there between SQL server 2008 and 2012 Pin
jkirkerx28-Oct-21 9:43
professionaljkirkerx28-Oct-21 9:43 
GeneralRe: How much difference is there between SQL server 2008 and 2012 Pin
phil.o28-Oct-21 9:58
mvephil.o28-Oct-21 9:58 
GeneralRe: How much difference is there between SQL server 2008 and 2012 Pin
jkirkerx28-Oct-21 10:09
professionaljkirkerx28-Oct-21 10:09 
QuestionRe: How much difference is there between SQL server 2008 and 2012 Pin
CHill602-Nov-21 0:10
mveCHill602-Nov-21 0:10 
AnswerRe: How much difference is there between SQL server 2008 and 2012 Pin
jkirkerx2-Nov-21 7:45
professionaljkirkerx2-Nov-21 7:45 
I'm working on a project written by 3 Chinese kids from China that were here at UC Irvine to study back in 2000 written in PHP over the course of 8 years. They made some bad choices in database design and I'm not about to change the database since I don't have a full understanding of how the program works. Well I do now after rewriting the PHP since Feb 2021. These kids had disrespect for HTML as well, and the worst programming disciplines I have ever seen.

In PHP 7.4, converting the date to a ISO formatted string speed ed up the process of converting that date into a PHP date object for my Calculation.Factory.PHP to process formulas, which generates the cost of an activity or specific job in the construction industry. And for some reason, technical, writing a PHP date back to SQL server required a different date conversion in SQL.

What was most frustrating was reading a date in SQL, and writing it back to another table in the same format, and SQL server would not write it unless it was in a certain ISO format.

The main point of this project was to get the existing code re imagined and upgraded from PHP 4.2 to PHP 7.4+ to extend the life of the application another 20 years.

I know why the dates had to be converted but I don't know how to work around this without altering the database design at this point in time. Excellent question which is making think about the dates again.

The original SQL did cast the date, but I can't remember at the moment why I had to remove the CAST, that was 8 months ago.
If it ain't broke don't fix it
Discover my world at jkirkerx.com

QuestionArray Issue Pin
MekaC24-Oct-21 17:59
MemberMekaC24-Oct-21 17:59 
AnswerRe: Array Issue Pin
Richard Deeming24-Oct-21 22:05
mveRichard Deeming24-Oct-21 22:05 
GeneralRe: Array Issue Pin
MekaC25-Oct-21 11:13
MemberMekaC25-Oct-21 11:13 
AnswerRe: Array Issue Pin
Richard MacCutchan24-Oct-21 22:07
mveRichard MacCutchan24-Oct-21 22:07 
GeneralRe: Array Issue Pin
MekaC25-Oct-21 11:14
MemberMekaC25-Oct-21 11:14 
AnswerRe: Array Issue Pin
jkirkerx28-Oct-21 9:04
professionaljkirkerx28-Oct-21 9:04 
QuestionLooking for feedback and contributions to database project Pin Pin
Michael Sydney Balloni17-Oct-21 13:06
mvaMichael Sydney Balloni17-Oct-21 13:06 
QuestionHow to write stored procedure in mysql workbench. SELECT, INSERT, UPDATE,DELETE Pin
Member 1539388914-Oct-21 0:05
MemberMember 1539388914-Oct-21 0:05 
AnswerRe: How to write stored procedure in mysql workbench. SELECT, INSERT, UPDATE,DELETE Pin
Richard MacCutchan14-Oct-21 0:33
mveRichard MacCutchan14-Oct-21 0:33 
AnswerRe: How to write stored procedure in mysql workbench. SELECT, INSERT, UPDATE,DELETE Pin
CHill6022-Oct-21 0:08
mveCHill6022-Oct-21 0:08 
Questionremove Pin
Member 1489067811-Oct-21 20:23
MemberMember 1489067811-Oct-21 20:23 
AnswerRe: Sql Match Pin
OriginalGriff11-Oct-21 20:24
mveOriginalGriff11-Oct-21 20:24 
Question[Resolved] Need Help with this SQL Statement Pin
crmfghtr5-Oct-21 14:24
Membercrmfghtr5-Oct-21 14:24 
AnswerRe: Need Help with this SQL Statement Pin
Richard Deeming5-Oct-21 21:48
mveRichard Deeming5-Oct-21 21:48 
GeneralRe: Need Help with this SQL Statement Pin
crmfghtr6-Oct-21 2:37
Membercrmfghtr6-Oct-21 2:37 
GeneralRe: Need Help with this SQL Statement Pin
Richard Deeming6-Oct-21 3:36
mveRichard Deeming6-Oct-21 3:36 
GeneralRe: Need Help with this SQL Statement Pin
Eddy Vluggen8-Oct-21 15:23
professionalEddy Vluggen8-Oct-21 15:23 

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.