[Help] SQL Query

Page 1 of 2 1 2
07/26/2014 08:02 Little Messi#1
i used this query to fix problem, that mobs don't spawn
but it missed up my npc's places. new uniques places added. and reseted it to the basic DB.

here's the query i want to reverse it, or disable it.
NOTE: i can't restore the DB.

here's the query
Code:
DELETE FROM [SRO_VT_SHARD ].[dbo].[Tab_RefNest] 
USE [SRO_VT_SHARD]
GO
BULK INSERT Tab_RefNest FROM 'C:\RefNEst.txt' WITH (FIELDTERMINATOR = '\t')
07/26/2014 15:34 Snow*#2
Different _RefObjCommon ID's
07/26/2014 21:04 Little Messi#3
Quote:
Originally Posted by SnowStorm1 View Post
Different _RefObjCommon ID's
and how to get it back like the old _RefNest of my db ??
07/27/2014 00:28 Royalblade*#4
Look.

DELETE FROM [SRO_VT_SHARD ].[dbo].[Tab_RefNest]

Do you see the first word? It says DELETE. You DELETED something. Forget about getting it back again.
07/27/2014 00:54 Zodiao#5
What you can do is:
1. TRUNCATE TABLE SRO_VT_SHARD.dbo.Tab_RefNest

2. Restore your database(Nearest backup) to a new database (For ex: SRO_VT_SHARD1)

3. Select * FROM SRO_VT_SHARD1.dbo.Tab_RefNest

4. Copy the contents you have copied to SRO_VT_SHARD.dbo.Tab_RefNest.

Note: Create a database backup before you do any of this as it's not guranteed.

Good luck
07/27/2014 11:30 Syloxx#6
Quote:
Originally Posted by Sir*EviL View Post
What you can do is:
1. TRUNCATE TABLE SRO_VT_SHARD.dbo.Tab_RefNest

2. Restore your database(Nearest backup) to a new database (For ex: SRO_VT_SHARD1)

3. Select * FROM SRO_VT_SHARD1.dbo.Tab_RefNest

4. Copy the contents you have copied to SRO_VT_SHARD.dbo.Tab_RefNest.

Note: Create a database backup before you do any of this as it's not guranteed.

Good luck
again... unprofessional ;) because IDīs will not match

1. DROP TABLE SRO_VT_SHARD.dbo.Tab_RefNest
2. Restore your Database with name SRO_VT_SHARD_Restore
3. Run This Query:

Code:
SELECT * INTO SRO_VT_SHARD.dbo.Tab_RefNest FROM SRO_VT_SHARD_Restored.dbo.Tab_RefNest
Sir*Evil dont call you a DB Developer if u cant even restore a single table...
07/27/2014 19:33 Zodiao#7
Quote:
Originally Posted by Syloxx View Post
again... unprofessional ;) because IDīs will not match

1. DROP TABLE SRO_VT_SHARD.dbo.Tab_RefNest
2. Restore your Database with name SRO_VT_SHARD_Restore
3. Run This Query:

Code:
SELECT * INTO SRO_VT_SHARD.dbo.Tab_RefNest FROM SRO_VT_SHARD_Restored.dbo.Tab_RefNest
Sir*Evil dont call you a DB Developer if u cant even restore a single table...

Hmm, Mr. Show off

Let me explain it to you as you are a brainless kid
I didn't say to restore any database I said "YOUR" database, which why the IDs will match, dumba$$
Also what you said is exactly what i said, so you didn't add anything but the query which can be done normally too without using a query, stop showing off because you are bad at it :)
07/28/2014 07:40 Syloxx#8
Quote:
Originally Posted by Sir*EviL View Post
Hmm, Mr. Show off

Let me explain it to you as you are a brainless kid
I didn't say to restore any database I said "YOUR" database, which why the IDs will match, dumba$$
Also what you said is exactly what i said, so you didn't add anything but the query which can be done normally too without using a query, stop showing off because you are bad at it :)
And again, no clue about joymax database:

a unedited Joymax Table use automatic identify

means...

if u insert a row doenst matter what ID u insert the database will replace it with the lastest ID +1

and we all know that Joymax have some gaps in the Tables example:

Joymax have this kind of ids

100
101
102
154
155

if u copy and insert this now in a TRUNCATED table following will happen.

IDīs will be replaced with

100
101
102
103
104

this is why IDs will not match

srysl because ppl like u there are so many queries / tables in dbs where i just wanna cry...

im one of the guys who have to fix your shit

and btw my query does not do the same like you

with my query the table will get copied not just the content that means also the IDs will match!

u show again that you are not a db developer cmon please stop it... you disfigure your self

new Signature for you:

[Only registered and activated users can see links. Click Here To Register...]
07/28/2014 16:09 Zodiao#9
You do know that the Tab_Refnest has automatic identify on NestID only?
Which can be whatever the hell it would be, as it's not linked to any other shit? no. k bye :)

so again you should really stop showing off :)
07/28/2014 16:21 Syloxx#10
Quote:
Originally Posted by Sir*EviL View Post
You do know that the Tab_Refnest has automatic identify on NestID only?
Which can be whatever the hell it would be, as it's not linked to any other shit? no. k bye :)

so again you should really stop showing off :)
sure i know it, it does not change the fact that IDs will not match with the original or?

did i ever said it wont not work ?

i said unprofessional

try to restore Hive / Tactics on your way :D

this kind of tables wont work

or tell me please
how you would restore _RefObjCommon

please tell me that im very excited
07/28/2014 16:26 Zodiao#11
Quote:
Originally Posted by Syloxx View Post
sure i know it, it does not change the fact that IDs will not match with the original or?

did i ever said it wont not work ?

i said unprofessional

try to restore Hive / Tactics on your way :D

this kind of tables wont work

You really should stop embarrassing yourself,
Why the hell would I want my IDs matching? so it can fit out my new dress?
seriously?
You are really not even good at it,
And nope you didn't know it, that's why you found the way around with Hive, Tactics.. also If you are that good you shouldn't feel burnt that way ;)
07/28/2014 16:37 Syloxx#12
Quote:
Originally Posted by Sir*EviL View Post
You really should stop embarrassing yourself,
Why the hell would I want my IDs matching? so it can fit out my new dress?
seriously?
You are really not even good at it,
And nope you didn't know it, that's why you found the way around with Hive, Tactics.. also If you are that good you shouldn't feel burnt that way ;)
srysl u think i dont know how to check which column is marked for auto identify?

short tutorial for you:

Rightclick > Design on table:

[Only registered and activated users can see links. Click Here To Register...]

Key = auto identify
there u can also see if the column allows null or not and what data Type is stored there ;)

anyway i still waiting for the query "how to restore _RefObjCommon" i cant do it can u please gime a query
07/28/2014 16:39 Zodiao#13
So that way you switched the subject the fact that you made yourself a total idiot?

W/e not replying to this anymore, you just made yourself a total idiot AGAIN...
See ya arrogant kid.(Fails to be that too)
What a fail!

also what the hell is srysl?
07/28/2014 16:49 Syloxx#14
Quote:
Originally Posted by Sir*EviL View Post
So that way you switched the subject the fact that you made yourself a total idiot?

W/e not replying to this anymore, you just made yourself a total idiot AGAIN...
See ya arrogant kid.(Fails to be that too)
What a fail!

also what the hell is srysl?
nope i didnt switched the subject

we sill talking about restore tables and what happen with the IDs so we just changed a table name and btw :D

and i just want to hear from you:

"yes ok my method is worse / unprofessional" then everything is good.
btw just because u can setup a SRO Server and make some simple changes you are not an Developer!
07/29/2014 08:17 鳳凰城#15
Quote:
Originally Posted by Syloxx View Post
again... unprofessional ;) because IDīs will not match

1. DROP TABLE SRO_VT_SHARD.dbo.Tab_RefNest
2. Restore your Database with name SRO_VT_SHARD_Restore
3. Run This Query:

Code:
SELECT * INTO SRO_VT_SHARD.dbo.Tab_RefNest FROM SRO_VT_SHARD_Restored.dbo.Tab_RefNest
Sir*Evil dont call you a DB Developer if u cant even restore a single table...
So someone with random female render from google images with some paint .net text SyLoXoXOoxXXoxo is the developer right?
writing
like

this

is


the
developer

Quote:
Originally Posted by Syloxx View Post
nope i didnt switched the subject

we sill talking about restore tables and what happen with the IDs so we just changed a table name and btw :D

and i just want to hear from you:

"yes ok my method is worse / unprofessional" then everything is good.
btw just because u can setup a SRO Server and make some simple changes you are not an Developer!
Egyptian alert.



*i'm egy maself*
Page 1 of 2 1 2