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 1714075444
Design for simplicity, add complexity only where you must.
Home
Notebook
Contact us