Using the script yourself can perform your own feature, the package cursor operation stored procedure as follows: Create Procedure PR_EXECSQL2 @asqlstring varchar (8000) - Enter SQL Statement AS EXEC ('- Start Transaction Begin Tran Declare @asql varchar (8000) Declare TNames_Cursor CURSOR LOCAL FAST_FORWARD FOR ' @asqlstring ' OPEN tnames_cursor FETCH NEXT FROM tnames_cursor INTO @ASql WHILE (@@ FETCH_STATUS = 0) BEGIN print @ASqlEXEC (@ASql) IF @@ ERROR <> 0 GOTO FINALEXIT FETCH NEXT FROM tnames_cursor INTO @ ASql END CLOSE tnames_cursor DEALLOCATE tnames_cursor COMMIT TRAN RETURN FINALEXIT: ROLLBACK TRAN CLOSE tnames_cursor DEALLOCATE tnames_cursor ') using the method: declare @sql varchar (8000) set @ sql =' select '' update a set aa = '' ba from b 'exec PR_EXECSQL2 @SQL
