[Help] SQL Query

[Little Messi]

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

DELETE FROM [SRO_VT_SHARD ].[dbo].[Tab_RefNest] 
USE [SRO_VT_SHARD]
GO
BULK INSERT Tab_RefNest FROM 'C:\RefNEst.txt' WITH (FIELDTERMINATOR = '\t')

[Snow*]

Different _RefObjCommon ID's

[Little Messi]

Originally Posted by SnowStorm1

Different _RefObjCommon ID's

and how to get it back like the old _RefNest of my db ??

[Royalblade*]

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.

[Zodiao]

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

[Syloxx]

Originally Posted by Sir*EviL

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:

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...

[Zodiao]

Originally Posted by Syloxx

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:

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

[Syloxx]

Originally Posted by Sir*EviL

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 ****

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:

[Zodiao]

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 ****? no. k bye

so again you should really stop showing off

[Syloxx]

Originally Posted by Sir*EviL

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 ****? 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

this kind of tables wont work

or tell me please
how you would restore _RefObjCommon

please tell me that im very excited

[Zodiao]

Originally Posted by Syloxx

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

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

 Spoiler

[Syloxx]

Originally Posted by Sir*EviL

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

 Spoiler

srysl u think i dont know how to check which column is marked for auto identify?

short tutorial for you:

Rightclick > Design on table:



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

[Zodiao]

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?

[Syloxx]

Originally Posted by Sir*EviL

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

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!

[鳳凰城]

Originally Posted by Syloxx

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:

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

Originally Posted by Syloxx

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

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*