2010-12-21, 02:55 PM
2010-12-21, 05:10 PM
if this is MS SQL, then your DB owner is in the wrong spot and you should wrap the select in ()
INSERT INTO o2jamfinal.dbo.member (userid,usernick,sex,passwd,registdate,id9you,vip,vipdate,activation_code,email,activateip,regip,activated )
(SELECT userid,usernick,sex,passwd,registdate,id9you,vip,vipdate,activation_code,email,activateip,regip,activated FROM oldo2jam.dbo.member)
2010-12-21, 05:17 PM
DENIED SUPPORT = DENIED PARTICIPATION
Im off, heading to vBulletin
Sorry guys
Im off, heading to vBulletin
Sorry guys
2010-12-21, 05:20 PM
doedws
(SELECT userid,usernick,sex,passwd,registdate,id9you,vip,vipdate,activation_code,email,a​ctivateip,regip,activated FROM oldo2jam.dbo.member)
return data or the error? be sure that you are "using" o2jamfinal database, as this will very cross database connectivity.
(SELECT userid,usernick,sex,passwd,registdate,id9you,vip,vipdate,activation_code,email,a​ctivateip,regip,activated FROM oldo2jam.dbo.member)
return data or the error? be sure that you are "using" o2jamfinal database, as this will very cross database connectivity.
2010-12-21, 05:31 PM
DENIED SUPPORT = DENIED PARTICIPATION
Im off, heading to vBulletin
Sorry guys
Im off, heading to vBulletin
Sorry guys
2010-12-21, 06:09 PM
yeah it does, the code block is doing something weird. I deleted the spaces from the stuff I pasted and it showed back up upon posting.
glad you got it working
glad you got it working