Library 4 Web

SQL insert increment DateAdd

Sep 11

taitranUncategorized 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