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.
Aerocool DS 200 Lite/ Corsair GS600/ ASRock Fatal1ty Z97 Killer/ Intel Core i5 4670K 3,40 GHz 6MB Cache/ Corsair Water Cooler H80i/ Sapphire R9270X Dual-X 2GB OC/ Hyper X Fury 2x8GB 1866Mhz DDR3/ SSD Kingston 120GB/ HDD Samsung 500GB
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
Há 1 usuários navegando neste tópico. (0 registrados e 1 visitantes)
Regras do Fórum