USE [webSite] GO GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO declare @memb___id varchar(10); declare c cursor for select memb___id FROM MEMB_INFO open c FETCH NEXT FROM c INTO @memb___id WHILE @@FETCH_STATUS = 0 BEGIN IF NOT EXISTS (SELECT 1 FROM webSite.dbo.webCash WHERE username=@memb___id) INSERT INTO webSite.dbo.webCash (username, amount) VALUES (@memb___id, 0) FETCH NEXT FROM c INTO @memb___id END CLOSE c DEALLOCATE c declare c cursor for select memb___id FROM MEMB_INFO open c FETCH NEXT FROM c INTO @memb___id WHILE @@FETCH_STATUS = 0 BEGIN IF NOT EXISTS (SELECT 1 FROM webSite.dbo.webVips WHERE username=@memb___id) INSERT INTO webSite.dbo.webVips (username, type, dateBegin, dateEnd) VALUES (@memb___id, 0, '0','0') FETCH NEXT FROM c INTO @memb___id END CLOSE c DEALLOCATE c ---------- Não entendo muito mas está query está com erro,query serve para que? DB xteam S4 Msg 208, Level 16, State 1, Line 3 Nome de objeto 'MEMB_INFO' inválido.
Há 1 usuários navegando neste tópico. (0 registrados e 1 visitantes)
Regras do Fórum