Viewing 15 posts - 1 through 15 (of 747 total)
. Did you know there's an ISO 8601 standard for the week within a year display format of the date? It looks like "yyyyW[0-5][0-9]-[0-7]", where "yyyy" is the calendar year,...
January 14, 2021 at 10:40 pm
>> I have this function, but I wanted to pass a table so as to use the same function to get the job done for multiple tables. For example, I...
January 13, 2021 at 10:42 pm
>> Jcelko... not sure what your issue is, we all get tired of seeing repeat mistakes but there are times for discretion and actual help as well. <<
I'm a grumpy...
January 6, 2021 at 3:04 pm
In the future, would you mind following the basic netiquette that's been in effect for over 30 years on SQL forums and post real DDL?
CREATE TABLE Inventory
(gtin CHAR(15) NOT NULL...
January 6, 2021 at 4:55 am
For over 30 years, SQL forms have required that you post DDL. Why do you feel you are exempt? Let me go ahead and do what you should have done...
January 6, 2021 at 4:30 am
Why did you fail to post DDL? Have you ever read any of the posting rules on any SQL forum for the past 30+ years? Why do you think anyone's...
January 6, 2021 at 3:34 am
I've been teaching SQL and RDBMS for a few decades now. I spent 10 years of my life. The standards committee for the language and have 10 books on it...
January 5, 2021 at 5:18 am
First, would you explain why you didn't post any DDL. This is been basic netiquette for over 30 years on SQL forms. Why are you exempt?
Second, your narrative is wrong....
January 4, 2021 at 9:50 pm
Your approach to SQL is completely wrong. Client/server architectures are based on tiers. One of these tears is a displayed level, which is where we put in commas and punctuation...
January 4, 2021 at 9:10 pm
You don't seem to know the table must have a key. By definition, not as an option. Furthermore, we cannot be all NULLs. Basically, you posted a very badly designed...
January 4, 2021 at 9:00 pm
If you actually need a sequence, then we have a CREATE SEQUENCE statement in the language I need to just generate a set of integers then I would use
January 3, 2021 at 9:15 pm
The dash-dash marks a comment that ends at the newline. This convention comes from IBM and punchcards in the early days of DB2.
January 2, 2021 at 10:42 pm
>> I am trying to add a column to a table that ranks the number of occurrences of repeated data. All I can currently find is how to count the...
December 31, 2020 at 8:13 pm
>> I remember learning Algol during a teacher strike while I was in High School back when dinosaurs still roamed the land. I actually liked the language. <<
I learned Fortran...
December 29, 2020 at 5:26 pm
A little bit of history here. The ANSI/ISO Standards committee decided that the grammar for SQL would be LALR(1). One of the committee members had access to a really good...
December 28, 2020 at 3:40 pm