Skip to navigation
Set 112 date if not exists in mssql
15.06.20
IF NOT EXISTS(SELECT 1 FROM daily_reports WHERE [date] = CONVERT(VARCHAR(10),GETDATE(),112)) INSERT INTO [SL_h].[dbo].[daily_reports]([date]) VALUES( CONVERT(VARCHAR(10),GETDATE(),112))
Reply
Anonymous
Information Epoch 1753688865
Choose portability over efficiency.
Home
Notebook
Contact us
