Viewing 15 posts - 1,021 through 1,035 (of 1,396 total)
... 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
Imo expressing the recursive "downlines" or "sort path" as nested json makes the information much more usefully accessible. You can check out an example at:
Can you use the...
April 25, 2020 at 3:51 pm
Imo expressing the recursive "downlines" or "sort path" as nested json makes the information much more usefully accessible. You can check out an example at:
April 25, 2020 at 2:07 pm
What is the DBA world consensus on using this to implement databases for an application? An application developer presented this as the "future of EF" but I do not...
April 25, 2020 at 2:44 am
Yeah I noticed that too. My next attempt would be to use CROSS APPLY containing IIF function(s) (as many as necessary) and pass in a ton of variables.
April 21, 2020 at 5:41 pm
Viewing 15 posts - 1,021 through 1,035 (of 1,396 total)