Hi,

I encountered this kind of issues due to mismatch between the SET properties in the workload. I guess you are getting two plans as you are running one...

Hi Mauricio,

How about the approach below:

DROP TABLE IF EXISTS #CSV
CREATE TABLE #CSV
(ID INT NOT NULL,
LIST VARCHAR(30) NOT NULL
)

INSERT INTO #CSV

Hi,

If you are using SQL 2016 (compatibility level 130), you can achieve this by the following way:

DECLARE @Input VARCHAR(100) = '(DD)(GG)(BBB)(AAA)'
SELECT @Input = REPLACE(@Input,')','')
SELECT...

Hi,

Can you try the DMV sys.dm_exec_connections (look for the client_net_address column in the resultset)?

Thanks.

Hi Komal,

Please try putting the ON clause before WITH clause. So it might look like
CREATE TABLE [Comp].[Model](
[Model] [nvarchar](255) NOT NULL,
  [ModelCondition] [nvarchar](100) NULL...

Hi 89netanel,

I assume you have primary key foreign key dependencies defined in your tables. If that is the case, then you can find the list of dependent tables...

Hi,

You can try various options on the database level, like updating the COMPATIBILITY_LEVEL to 130 since you upgraded from SQL 2012 to 2016, it might still be 110...

Hi,

Have you tried enclosing  the value in single-quotes?

I mean JSON_MODIFY(@j, 'append $.size', '1000')

Please let us know.