Viewing 15 posts - 1,021 through 1,035 (of 1,401 total)
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
I could be wrong but I'm pretty sure that's not what the OP is talking about. I believe he's talking about the front-end Developers creating the tables on the...
April 27, 2020 at 12:39 pm
That's freaking amazing. It's awesome to see real in depth analysis. Thank you for doing this.
Shifting gears a bit, since the Nested Sets method has most of...
April 27, 2020 at 11:58 am
That's freaking amazing. It's awesome to see real in depth analysis. Thank you for doing this.
Shifting gears a bit, since the Nested Sets method has most of the goodies...
April 26, 2020 at 10:44 pm
Those columns are not needed, I think. At the end of the 2nd article (allow me to quote you some Jeff Moden) it says:
Last but certainly not least, if you...
April 26, 2020 at 1:34 pm
Viewing 15 posts - 1,021 through 1,035 (of 1,401 total)