DECLARE

    @ids varchar(1000);

SET @ids = '1,a,3,';

BEGIN TRY

    BEGIN TRAN;

    -- 循环分拆@ids 中以逗号分隔的每个id

    WHILE CHARINDEX(',', @ids) > 0

    BEGIN

       DECLARE

           @id int;

       BEGIN TRY

           -- 获取当前的id

           SET @id =LEFT(@ids, CHARINDEX(',', @ids) - 1);

       END TRY

       BEGIN CATCH

           -- 从@ids 中去掉当前的id

           SET @ids = STUFF(@ids, 1, CHARINDEX(',', @ids), '');

           CONTINUE;

       END CATCH

       -- 从@ids 中去掉当前的id

       SET @ids = STUFF(@ids, 1, CHARINDEX(',', @ids), '');

       -- 处理id

       RAISERROR('current id: %d', 10, 1, @id) WITH NOWAIT;

    END

    COMMIT TRAN;

END TRY

BEGIN CATCH

    IF XACT_STATE() <> 0

       ROLLBACK TRAN;

    SELECT

       err_line = ERROR_LINE(),

       err_message = ERROR_MESSAGE();

END CATCH

current id: 1

current id: 3

   err_line err_message

----------- -------------------------------------------------------

         30 当前事务无法提交，而且无法支持写入日志文件的操作。请回滚该事务。

(1 行受影响)