Viewing 15 posts - 1,006 through 1,020 (of 1,396 total)
Interesting. Does it correctly handle names like MacDonald, McDonald, van Halen, O'Leary, and things like "This is a Book"?
I think it's pretty basic. iirc "select initcap('This is a Book')...
May 14, 2020 at 8:45 pm
It's title caps. In Oracle since 8i
May 14, 2020 at 7:24 pm
Incorporating Jeff's improvements and refactoring again this is what I came up. Since this is the 2019 thread I created an INITCAPS scalar function which should execute inline, although it's...
May 14, 2020 at 4:34 pm
Jeff, you have 2 solutions here, which is the preferred? I like the 2nd one. And why is there no INITCAP() function in SQL Server? That's waaaay overdue.
Regarding labeling query...
May 14, 2020 at 12:52 pm
This is really good. The syntax is a little inconsistent and the use of sub-queries instead of cte's is not really considered current. Also, no need for the floor function...
May 13, 2020 at 8:47 pm
Hi pietlinden, I saw this yesterday and was going to reply but then got distracted. Is the ToxBad table in the structure it was received or did you normalize what...
May 13, 2020 at 12:22 pm
I I've been taking SQL for many decades, this literally was the best analogy I can come up with. Please give me a better one so I can use...
May 12, 2020 at 8:33 pm
You keep trolling this forum with things that indicate either youth or ignorance.
If you could point out some specific examples I would truly appreciate it.
May 12, 2020 at 7:34 pm
No, it is not a Ferrari. It is a database engine aimed at a particular market niche. It does it very nicely in many ways, but it is not...
May 12, 2020 at 6:53 pm
After I get it working (working first, optimize later), then I can tuned it, attach add-ons or whatever. If you can find a good book on it, in the...
May 12, 2020 at 1:25 pm
drop table if exists #data;
create table #data(
id int primary key not null,
name_id int,
...
May 11, 2020 at 2:56 pm
Whenever there is a change in Status or Comment for name_id then we need to consider that record
The table could be altered so it becomes a "System-Versioned" temporal table. ...
May 11, 2020 at 12:52 pm
When you set something to zero like this, you're changing the data,you're destroying the fact which Chris Date and I think most other RDBMS experts feel is a really...
May 11, 2020 at 12:01 pm
By analogy, it is like the parking space in the garage in your car is the data element.
So a 2D piece of physical capital is the best analogy...
May 11, 2020 at 11:06 am
The SEQUENCE and IDENTITY are two very different things. The IDENTITY table property is a very proprietary, totally non-relational, feature in SQL Server. By analogy, it is like the...
May 11, 2020 at 11:03 am
Viewing 15 posts - 1,006 through 1,020 (of 1,396 total)