SQL Server

• MSDTCを動作させるために必要な設定について
  • https://blogs.technet.microsoft.com/jpiis/2018/02/05/msdtc-settings/

Functions

• DATEADD(type, interval, sourcedate)
• CONVERT(varchar(20), getdate(), 120)
  • https://talklowy-jp.blogspot.com/2020/06/sql-server-convert-datetime.html

JSON Query

JSON Query can be used over sql server 2015(?).

• You must filter to existed data, or get error

select * 
from (
	select top 200 * 
	from <tablename>
	where <jsonfield> like '%status%'
) A
where
	JSON_VALUE(<jsonfield>, '$."status"') = 0

• https://docs.microsoft.com/ja-jp/sql/t-sql/functions/json-modify-transact-sql?view=sql-server-ver15