The 4000 series Ryzen CPUs seem to be great value in terms of performance/power.  H-series are competitive with desktop chips for performance. U-series have more moderate performance, and are geared...

So we have noticed our trigger that does insert from one table to another if there is an update or insert, so we noticed the timestamp GETDATE() has been from...

You have a nested array.

SELECT JSON_VALUE(@JsonValue, '$.CoordSets[0][0].Lat');--returns 51.9642514

Are the double square brackets intentional?

With SQL Server 2019, you can enable trace flag 460 to get detailed messages that identify the column and even offending value.

https://techcommunity.microsoft.com/t5/sql-server/string-or-binary-data-would-be-truncated-replacing-the-infamous/ba-p/386014

https://www.brentozar.com/archive/2019/03/how-to-fix-the-error-string-or-binary-data-would-be-truncated/

More or less, eventually, depending on whether you're looking at raw or compressed data size... And assuming your client doesn't time out or crash from an out-of-memory condition.

Once client-side, the...

Thanks to TSQL's support of updates with from clauses, I frequently write new or ad-hoc updates in this format (at least in development) to make testing easy:

update...

Sequence?

No.

How were DDColumnObject and DDErrorLog modified?  via SSMS GUI? Or with TSQL alter table statements?

If you used the GUI, it may have re-created the tables rather than simply altering.

The trigger (and insert) would be on the view if you're trying to prevent insert into dbo.Badgeid and instead insert into Badgeid2.

Are you saying you also still want data inserted...

1. Assuming you're doing this in SSMS, you need a GO statement after your trigger definition.  Otherwise, your insert and select are just part of the trigger definition, and are...

Not the original question, but bubbling up unchanged error is another advantage of THROW. If you want to bubble up the error, unchanged, you can simply call THROW, and it...

• This reply was modified 4 years, 4 months ago by  ratbak.

"SELECT CASE WHEN NULL = NULL THEN 'No' ELSE 'Yes' END AS Result

Result would be no because one null value cannot be equal to another because null means 'UNKNOWN'."

Perhaps just...

You probably want a covering index like:

CREATE NONCLUSTERED INDEX ncix_PropertyProduct_Cover ON dbo.PropertyProduct
(
Warehouse ASC,
Product ASC
)
INCLUDE(Id,PropertyId,Value);

SELECT CAST(ROUND(COLUMN_A*100.0/(CASE WHEN COLUMN_B = 0 THEN -1 ELSE COLUMN_B END),2) as decimal(5,2)) as "Percentage"

You lost the ROUND() function's length parameter in that version

You can use gzip. But make sure you use 7z.exe, not 7za.exe -- https://sevenzip.osdn.jp/chm/cmdline/index.htm:

7za.exe supports only 7z, xz, lzma, cab, zip, gzip, bzip2 and tar formats.

https://sevenzip.osdn.jp/chm/cmdline/switches/type.htm:

If...