473,396 Members | 1,683 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Does there have any undo or rollback function in SQL server?

6
When we update or delete data... it's very serious and seem to no choice to rollback. How does everyone to control this part of situation?

thanks for the opinion.
Nov 1 '07 #1
5 1810
debasisdas
8,127 Expert 4TB
As you have posted a question in the articles section it is being moved to SQL Server Forum.
Nov 1 '07 #2
Gison
6
As you have posted a question in the articles section it is being moved to SQL Server Forum.
sorry.. and thank you.
Nov 1 '07 #3
jamesd0142
469 256MB
When we update or delete data... it's very serious and seem to no choice to rollback. How does everyone to control this part of situation?

thanks for the opinion.
im my case i have a backup routine which runs every night, can you not restore from a backup?
Nov 1 '07 #4
pralay
1
When we update or delete data... it's very serious and seem to no choice to rollback. How does everyone to control this part of situation?

thanks for the opinion.

yes. you can use transaction to handle this situation.
some commands are there

BEGIN TRANSACTION
<sql code>
COMMIT / ROLLBACK TRANSACTION

for more use the msdn help.
Nov 1 '07 #5
debasisdas
8,127 Expert 4TB
You can always rollback the transaction before commiting it.
Nov 1 '07 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: s-galit | last post by:
im trying to use the undo function of the richTextBox but its working wrong. when im pressing the "undo" button all the text of the richTextBox is deleted (even if my last action was to delete only...
6
by: lkrubner | last post by:
I'm offering users the ability to type weblog posts into a form and post them. They type the text into a TEXTAREA which is on a form. The form, when submitted, hits a PHP script. Before it is...
1
by: Sid Gudes | last post by:
Hi All, I'm converting a CLI application from Teradata to DB2. In Teradata, there is a conditional rollback, e.g. rollback where customer='1234' and ID=123 This does the rollback only if...
3
by: babylon | last post by:
any facilities in csharp that can help me implmenting undo/redo in my application? thx
11
by: Brian W | last post by:
Yet another editor problem To reproduce do the following 1) Open a Webform and switch to HTML edit mode 2) Enter the Following (include spaces) This is some text before <asp:hyperlink...
5
by: Jack | last post by:
Is there anyway in SQL Server to rollback an SQL statement which was already executed. I know there is a transaction log but what it contains and how it works is still a mystery to me. Assuming I...
4
by: =?Utf-8?B?UmljaA==?= | last post by:
Hello, Does vb2005 have a built-in UnDo feature / object for applications so that I can undo actions like other windows apps? Or do I have to write my own UnDo routine? If vb2005 does have a...
0
by: Arun Srinivasan | last post by:
Hi I am trying to write an undo handler within an atomic compound statement, but I get the following error. Operation invalid for application execution environment. Reason code = "22". ...
5
daniel aristidou
by: daniel aristidou | last post by:
Hi guys ..... I don't know about VB 2k5 but in VB08 there is an undo function on textboxes. I was wondering how to use it correctly with the Undo button in order to undo the last textbox change...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.