SQL insert increment DateAdd

No Comments

It requires increment date by one day into datetime field to illustrate that records has been entered from time to time.  

DECLARE @CNT INT
DECLARE @Barcode VARCHAR(13)

DECLARE UpdateCursor CURSOR FOR
 SELECT Barcode FROM ViewProducts — WHERE Barcode = @Barcode

SET @CNT = 1

OPEN UpdateCursor
FETCH NEXT FROM UpdateCursor INTO @Barcode

WHILE @@FETCH_STATUS = 0   
 BEGIN
   
  SELECT  @CNT = @CNT + 1
  
  UPDATE ViewProducts
  SET ModifyTime =  DATEADD( dd , @CNT,  GETDATE()) 
  WHERE Barcode = @Barcode
  
  FETCH NEXT FROM UpdateCursor INTO @Barcode
  
 END
 –FETCH NEXT FROM UpdateCursor INTO @Barcode
CLOSE UpdateCursor   
DEALLOCATE UpdateCursor

Leave a Reply