Get Error when using Execute command

Question

Get Error when using Execute command

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply

xiii29 Say Hey Kid Points: 695 More actions · Answer 1

Yes I try it and it is working. I do not get the error code but the transaction is not commited which is the most important for me.

I heard and understand what you said about the fact the system maybe dangerous but there is only others developpers of the project that are sending data ...

Thanks for all your help !

Sergiy SSC Guru Points: 110208 More actions · Answer 2

I believe you missed the topic "How restore the data from dropped table".

You cannot imagine what kind of queries developers can send.

_____________
Code for TallyGenerator

xiii29 Say Hey Kid Points: 695 More actions · Answer 3

As everything is in an Transaction (even the DROP TABLE), I hope the roll back of the transalation will be roolback !!!!

Otherwise, I think I will work on it

Thanks for your help !

Sergiy SSC Guru Points: 110208 More actions · Answer 4

Try it.

Not in production, of course.

See how much you can restore.

BTW, because I don't expect many errors during execution of DROP TABLE that transaction gonna be committed before you know it. Nothing to roll back.

_____________
Code for TallyGenerator