Viewing 15 posts - 1 through 15 (of 912 total)
Please consider learning standard SQL. We don't have an IFF() construct; that was spreadsheets and perhaps some nonrelational languages. Take the time to write everything out as a CASE expression....
April 17, 2024 at 9:32 pm
As an aside, MySQL had a proposal for extended ISO 8601 date formats. The idea was that the yyyy-mm-dd format which is the only one allowed in ANSI/ISO standard SQL...
February 23, 2024 at 5:14 pm
Yes. Arrgh! Next time I will need see the spelling correction is doing its job. Dijkstra taught the University of Texas in Austin before his death. State got a lot...
February 7, 2024 at 4:33 pm
Be glad you never had a class under Dykstra at UT. His favorite way of talking to students was to tell them "You're doing everything completely wrong!" But you knew...
February 6, 2024 at 9:00 pm
Why do you think you need a non-relational IDENTITY column in this table? The primary key is supposed to be unique already; this is a definition, not an option. Is...
February 5, 2024 at 9:53 pm
You're still writing SQL as if you were in BASIC or Fortran. Let's start off with the create table statement. By definition, and not as an option, table must have...
January 31, 2024 at 3:21 pm
Actually this was a discussion inside ANSI on this Before relational modeling, there were other conventions; one of the most popular was IDEF (I can't remember what it stands for),...
October 27, 2023 at 1:29 pm
For over 30 years, the convention on SQL forums has been to post DDL (so we know what the keys are the datatypes of columns, any important constraints, etc.) and...
October 13, 2023 at 9:08 pm
Please do a little research. There is an ISO 8601 standard for week numbers within a year. It's very popular in Scandinavian countries, and you can find lots of calendars...
October 9, 2023 at 8:23 pm
Everything you posted is horrible and needs to be redone. IDENTITY is a table property and cannot be used as a key. You have more NULLs in this one table...
October 2, 2023 at 9:37 pm
Let us try to clean up your code and help you build good habits since you are new to this. First of all, a table must have a key and...
September 25, 2023 at 11:33 pm
The first thing we need to do is get some valid DDL. Your singular table name indicate you have only one Rate. I’m pretty sure that’s not true. The vehicle...
September 18, 2023 at 7:02 pm
Your approach to SQL is wrong. This is a declarative language but you are writing code as if you were still doing Fortran with file systems. Instead of scratch tapes,...
September 1, 2023 at 6:38 pm
I think I'll go to the other extreme. I am waiting for eye surgery right now, so there will be a little delay, but I will develop an article for...
August 26, 2023 at 5:13 pm
You've made the usual beginner's mistake of confusing a table with a 1950s file system. We have had the daytime2(n) datatype for several years now, so there's no need to...
August 22, 2023 at 4:34 am
Viewing 15 posts - 1 through 15 (of 912 total)