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 1779128325
Use lower case and keep it short.
Home
Notebook
Contact us
