游标的使用

  DECLARE cursor_timeformatter CURSOR LOCAL FOR 
  SELECT ID, PublishTime FROM Book_BaseFields
  OPEN cursor_timeformatter
  DECLARE @ID int
  DECLARE @PublishTime nvarchar(50)
  WHILE @@FETCH_STATUS=0
  BEGIN
  FETCH NEXT FROM cursor_timeformatter INTO @ID, @PublishTime
  IF((Len(@PublishTime)-Len(Replace(@PublishTime,'-','')))=2)
    BEGIN
     UPDATE Book_BaseFields SET PublishTime = CONVERT(varchar(100),CAST(@PublishTime as DATETIME),23) WHERE ID=@ID
    END
  ELSE IF((Len(@PublishTime)-Len(Replace(@PublishTime,'-','')))=1)
    BEGIN
     IF(LEN(SUBSTRING(@PublishTime,6,2))=1)
       BEGIN
        UPDATE Book_BaseFields SET PublishTime = SUBSTRING(@PublishTime,1,5)+'0'+SUBSTRING(@PublishTime,6,2) WHERE ID=@ID
       END
    END
  END
  CLOSE cursor_timeformatter
  DEALLOCATE cursor_timeformatter
  GO