As separate statements maybe something like this

set xact_abort on;

begin transaction;
begin try
    update g
    set
      [skuId] =...

• This reply was modified 5 years, 6 months ago by Steve Collins.

JsonAutoService

And what does this sentence mean... "It isn't (and wasn't) possible to access the request route values from within the program delegate." ?...

Ok Jeff, I'll do whatever you suggest.  I'll submit something.

I'm intrigued, but I have absolutely no idea what this looks like in practice. Have you got a friendly introduction somewhere? Video? Some code to look at? And what...

It's an interesting approach.  I've cloned the repo.  Two things I like based on initial impression are the intellisense on db objects and the C# unit test codegen.

It's great to see this article!  I'm going to sit this pie fight out though.  Two items I would toss in fwiw:

1. The return type of the SCOPE_IDENTITY function is...

Nicely done!  It looks cleaned up now

No looping necessary.  Check out this script:

https://www.sqlservercentral.com/scripts/a-daterange-table-valued-function

It generates any range of days (or seconds or years...)

declare
  @start_day_num        int=5, /*...

drop table if exists dbo.test_j;
go
create table dbo.test_j(
  [data]         nvarchar(max));
go

insert dbo.test_j([data]) values('{"data": [{"id": "123", "title": "Webinar1", "nickname": "", "href":...

Sorry my answer was no good.  I tried to edit it and now it's been marked as spam for some reason.  If you posted a sample txt file it would...

Again, why is it "suboptimal"?  As long as the values are always ascending, what difference does it make to SQL, or to us, if there are gaps in the...

It really sounds like you should be using a SEQUENCE rather than an identity, that is, that this INSERT is just to get an identity value, which...

It really sounds like you should be using a SEQUENCE rather than an identity, that is, that this INSERT is just to get an identity value, which is no...

drop table if exists dbo.test_j;
go
create table dbo.test_j(
  j         nvarchar(max));
go

insert dbo.test_j(j) values('[{"id":"36653","invoicenumber":"8224131","billinginvoiceid":"948439"},{"id":"36651","invoicenumber":"8224133","billinginvoiceid":"948437"},{"id":"36652","invoicenumber":"8224134","billinginvoiceid":"948438"},{"id":"36654","invoicenumber":"8224155","billinginvoiceid":"948440"},{"id":"36655","invoicenumber":"8224161","billinginvoiceid":"948442"}]');

select j_open.* 
from 
  dbo.test_j j
 cross...

Nice.  Is there a unicode version?