sobre esses comandos

[Fhantasma 0]

DECLARE @Acc varchar(10), @Chars varchar(10), @test int

select @test = 0

DECLARE LISTA CURSOR LOCAL FOR

SELECT memb___id FROM MEMB_INFO

OPEN LISTA

FETCH NEXT FROM LISTA INTO @Acc

WHILE @@FETCH_STATUS = 0

begin

if (SELECT COUNT(*) FROM Character where AccountID=@Acc) = 0

begin

DELETE from MEMB_INFO where memb___id=@Acc

DELETE from VI_CURR_INFO where memb___id=@Acc

select @test = @test + 1

end

 

FETCH NEXT FROM LISTA INTO @Acc

end

CLOSE LISTA

DEALLOCATE LISTA

print @test

 

 

 

 

 

 

 

Esses tais comandos irao deletar os memb___id que nao tiverem nada na table character?

[ska_ska 0]

sim.. nas 2 tabelas que consta na query (MEMB_INFO e VI_CURR_INFO)

 

abs,

ska!