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 1732592415
Avoid hand-hacking, write programs to write programs when you can.
Home
Notebook
Contact us