--- sql 循环的应用 ---
-- 异常捕获--
-- memo: 日期转换失败跳过,循环继续执行,不捕获异常,则会中断执行 --
DECLARE @i int
SET @i=1
WHILE @i<50000
BEGIN
BEGIN TRY
UPDATE t_news set ptime = cast(pubtime as datetime) where id=@i
END TRY
BEGIN CATCH
PRINT @i
END CATCH
SET @i=@i+1
END