Viewing 15 posts - 1,006 through 1,020 (of 1,390 total)
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
... I should have just gone with the ubiquitous INT IDENTITY(1,1).
bingo
May 11, 2020 at 10:46 am
Dear scdecade,
Your function can not use in my database, my database running on SQL server 2014 and can not support JSON.
Pls help me fix it.
Thank you.
According to this article,...
May 3, 2020 at 2:33 pm
The REPLACE function can do many things in SQL Server. It's not really documented well and I usually have to experiment with it. When the REPLACE function is itself called...
April 30, 2020 at 4:10 pm
Just to add more history here. For application developers using SQL Server db's there used to be something called the Microsoft Enterprise Library. Among other things it included tools and...
April 29, 2020 at 3:41 pm
Are you saying that no one has created designs that exploit the inherent advantages of using stored procedures?
From a SQL perspective I'm not saying that at all. SQL developers...
April 27, 2020 at 9:04 pm
I'm talking about people using the front end designers to create tables. Some people do it right but, for the most part, it's done by people that have no...
April 27, 2020 at 7:26 pm
Viewing 15 posts - 1,006 through 1,020 (of 1,390 total)