Brisanje tHE_SetSubj

set nocount on

declare @nesto char (30)
declare xPoz cursor local fast_forward for
select acSubject from tHE_SetSubj where acSubject <> ''
open xPoz
fetch from xPoz into @nesto
while @@fetch_status = 0
begin
BEGIN TRY
delete tHE_SetSubj where acSubject = @nesto
end try

BEGIN CATCH
print 'Ne mogu obrisati: ' + @nesto
END CATCH
fetch from xPoz into @nesto
end
close xPoz
deallocate xPoz