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.