-
query erro musite 2.5
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.
-
Altere USE [webSite] para USE [MuOnline] e teste.
-
então a query é para ser usada em [webSite], faz parte da webSite_COMPLETE da musite
-
Mas a parte que usa a webSite ta especificada na query, a do MuOnline não.
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 MuOnline.dbo.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 MuOnline.dbo.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